COURSE INFORMATION Course Title: DATABASE MANAGEMENT SYSTEMS

Code	Course Type	Regular Semester	Theory	Practice	Lab	Credits	ECTS
CEN 202	B	4	2	1	1	3	6

Academic staff member responsible for the design of the course syllabus (name, surname, academic title/scientific degree, email address and signature)	NA
Lecturer (name, surname, academic title/scientific degree, email address and signature) and Office Hours:	Igli Hakrama
Second Lecturer(s) (name, surname, academic title/scientific degree, email address and signature) and Office Hours:	NA
Teaching Assistant(s) and Office Hours:	NA
Language:	English
Compulsory/Elective:	Compulsory
Classroom and Meeting Time:
Course Description:	This course aims to provide an introduction to the design and use of database systems. It includes a knowledge over the ER modeling and their use to create proper database tables in relational form, SQL coding techniques for DDL and DML, relational algebra, normalization techniques, as well as the key issues in building database management systems, and working with multiple database systems.
Course Objectives:	The objective of this course is to provide an introduction to the design and use of database systems. It includes a knowledge over the ER modeling and their use to create proper database tables in relational form, SQL coding techniques for DDL and DML, relational algebra, normalization techniques, as well as the key issues in building database management systems, and working with multiple database systems.

COURSE OUTLINE

Week	Topics
1	Introduction to DB concept
2	Data models and ER Model
3	ER Model
4	Basic SQL
5	Modeling and SQL
6	SQL Assertions and Views
7	Midterm
8	Relational Algebra
9	Normal forms
10	Stored Procedures
11	Optimizing Queries
12	Semi-structured data
13	Application of DB
14	Other Topics in DB

Prerequisite(s):	CEN 109 - Introduction to Algorithms and Programming
Textbook:	Fundamentals of Database Systems 7 Ed., Ramez Elmasri, Shamkant B. Navathe (Perarson 2016) Database System: The Complete Book 2 Ed., Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer, Widow (Pearson International Edition)
Other References:
Laboratory Work:	Yes
Computer Usage:	Yes
Others:	No

COURSE LEARNING OUTCOMES

1	Learn the concepts of Relational Database Systems
2	Analyze database requirements and develop logically the design of database
3	Model a database through ER Modeling
4	Implement a database through DDL instruction (sql)
5	Interact with the database through DML instruction (queries)
6	Evaluate and normalize a database
7	Make use of assertions, views, procedures and functions

COURSE CONTRIBUTION TO... PROGRAM COMPETENCIES (Blank : no contribution, 1: least contribution ... 5: highest contribution)

No	Program Competencies	Cont.
Bachelor in Computer Engineering (3 years) Program
1	Engineering graduates with sufficient theoretical and practical background for a successful profession and with application skills of fundamental scientific knowledge in the engineering practice.	5
2	Engineering graduates with skills and professional background in describing, formulating, modeling and analyzing the engineering problem, with a consideration for appropriate analytical solutions in all necessary situations	5
3	Engineering graduates with the necessary technical, academic and practical knowledge and application confidence in the design and assessment of machines or mechanical systems or industrial processes with considerations of productivity, feasibility and environmental and social aspects.	4
4	Engineering graduates with the practice of selecting and using appropriate technical and engineering tools in engineering problems, and ability of effective usage of information science technologies.	5
5	Ability of designing and conducting experiments, conduction data acquisition and analysis and making conclusions.	5
6	Ability of identifying the potential resources for information or knowledge regarding a given engineering issue.	4
7	The abilities and performance to participate multi-disciplinary groups together with the effective oral and official communication skills and personal confidence.	3
8	Ability for effective oral and official communication skills in foreign language.	1
9	Engineering graduates with motivation to life-long learning and having known significance of continuous education beyond undergraduate studies for science and technology.	5
10	Engineering graduates with well-structured responsibilities in profession and ethics.	4
11	Engineering graduates who are aware of the importance of safety and healthiness in the project management, workshop environment as well as related legal issues.	3
12	Consciousness for the results and effects of engineering solutions on the society and universe, awareness for the developmental considerations with contemporary problems of humanity.	3

COURSE EVALUATION METHOD

Method	Quantity	Percentage
Homework	1	15
Midterm Exam(s)	1	30
Final Exam	1	55
	Total Percent:	100%

ECTS (ALLOCATED BASED ON STUDENT WORKLOAD)

Activities	Quantity	Duration(Hours)	Total Workload(Hours)
Course Duration (Including the exam week: 16x Total course hours)	16	4	64
Hours for off-the-classroom study (Pre-study, practice)	16	3	48
Mid-terms	1	11	11
Assignments	5	3	15
Final examination	1	12	12
Other			0
Total Work Load:			150
Total Work Load/25(h):			6
ECTS Credit of the Course:			6