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
WeekTopics
1Introduction to Database Systems, Database System Concepts
2Entity-Relationship Model
3Enhanced Entity Relationship Model
4Relational Data Model
5Relational Algebra I
6Relational Algebra II
7Normalizing a database
8Midterm
9Introduction to SQL
10DML data manipulation instructions
11More DML instructions, DDL table creation instructions
12Introduction to MySQL, database design in MySQL
13Tables in MYSQL
14Retrive data from tables using MySQL statements
15Database Programming
16Final Exam
Prerequisites
Textbook
Other References
Laboratory Work
Computer Usage
Other
Learning Outcomes and Competences
1The students creates a simple database.
2The students does simple queries in the database.
3The student is familiar with the basic components of an RDBMS.
4The student manipulate the data of a database with SQL and MYSQL.
5The student is capable of administering a database.
Course Evaluation Methods
In-term studies Quantity Percentage
Midterms130
Quizzes00
Projects00
Term Projects00
Laboratory00
Attendance110
Contribution of in-term studies to overall grade40
Contribution of final examination to overall grade60
Total100
ECTS (Allocated Based on Student) Workload
Activities Quantity Duration
(hours)
Total Workload
(hours)
Course Duration (Including the exam week : 16 x Total course hours) 16464
Hours for off-the-classroom study (Pre-study, practice) 14342
Assignments 0100
Midterms 144
Final examination 155
Other 000
Total Work Load 115
Total Work Load / 25 (hours) 4.6
ECTS 5

Get Syllabus PDF (Albanian) Get Syllabus PDF (English)