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)