
Course Title : Databases | ||||||||
---|---|---|---|---|---|---|---|---|
Code | Course Type |
Regular Semester |
Lecture (hours/week) |
Seminar (hours/week) |
Lab (hours/week) |
Credits | ECTS | |
CMP 217-1 | B | 3 | 3 | 0 | 1 | 3.50 | 5 | |
Lecturer and Office Hours | ||||||||
Teaching Assistant and Office Hours | ||||||||
Language | Albanian | |||||||
Course Level | ||||||||
Description | ||||||||
Objectives | ||||||||
Course Outline | ||||||||
Week | Topics | |||||||
1 | Introduction to Database Systems, Database System Concepts | |||||||
2 | Entity-Relationship Model | |||||||
3 | Enhanced Entity Relationship Model | |||||||
4 | Relational Data Model | |||||||
5 | Relational Algebra I | |||||||
6 | Relational Algebra II | |||||||
7 | Normalizing a database | |||||||
8 | Midterm | |||||||
9 | Introduction to SQL | |||||||
10 | DML data manipulation instructions | |||||||
11 | More DML instructions, DDL table creation instructions | |||||||
12 | Introduction to MySQL, database design in MySQL | |||||||
13 | Tables in MYSQL | |||||||
14 | Retrive data from tables using MySQL statements | |||||||
15 | Database Programming | |||||||
16 | Final Exam | |||||||
Prerequisites | ||||||||
Textbook | ||||||||
Other References | ||||||||
Laboratory Work | ||||||||
Computer Usage | ||||||||
Other | ||||||||
Learning Outcomes and Competences | ||||||||
1 | The students creates a simple database. | |||||||
2 | The students does simple queries in the database. | |||||||
3 | The student is familiar with the basic components of an RDBMS. | |||||||
4 | The student manipulate the data of a database with SQL and MYSQL. | |||||||
5 | The student is capable of administering a database. | |||||||
Course Evaluation Methods | ||||||||
In-term studies | Quantity | Percentage | ||||||
Midterms | 1 | 30 | ||||||
Quizzes | 0 | 0 | ||||||
Projects | 0 | 0 | ||||||
Term Projects | 0 | 0 | ||||||
Laboratory | 0 | 0 | ||||||
Attendance | 1 | 10 | ||||||
Contribution of in-term studies to overall grade | 40 | |||||||
Contribution of final examination to overall grade | 60 | |||||||
Total | 100 | |||||||
ECTS (Allocated Based on Student) Workload | ||||||||
Activities | Quantity | Duration (hours) |
Total Workload (hours) |
|||||
Course Duration (Including the exam week : 16 x Total course hours) | 16 | 4 | 64 | |||||
Hours for off-the-classroom study (Pre-study, practice) | 14 | 3 | 42 | |||||
Assignments | 0 | 10 | 0 | |||||
Midterms | 1 | 4 | 4 | |||||
Final examination | 1 | 5 | 5 | |||||
Other | 0 | 0 | 0 | |||||
Total Work Load | 115 | |||||||
Total Work Load / 25 (hours) | 4.6 | |||||||
ECTS | 5 |
Get Syllabus PDF (Albanian) Get Syllabus PDF (English)