COURSE INFORMATION Course Title: ADVANCED DATABASE MANAGEMENT SYSTEM

Code	Course Type	Regular Semester	Theory	Practice	Lab	Credits	ECTS
CEN 552	B	2	3	2	0	4	7.5

Academic staff member responsible for the design of the course syllabus (name, surname, academic title/scientific degree, email address and signature)	NA
Main Course Lecturer (name, surname, academic title/scientific degree, email address and signature) and Office Hours:	Dr. Igli Hakrama ihakrama@epoka.edu.al
Second Course 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
Study program: (the study for which this course is offered)	Master of Science in Computer Engineering (2 years)
Classroom and Meeting Time:
Code of Ethics:	Code of Ethics of EPOKA University Regulation of EPOKA University "On Student Discipline"
Attendance Requirement:
Course Description:	This course covers advanced database management system design principles and techniques. Possible topics include access methods, Relational algebra, query processing and optimization, transaction processing, distributed databases, object-oriented databases, Distributed databases, data warehousing, Security, Backup and Recovery, Concurrency control techniques, etc.
Course Objectives:	Understand the functionality provided by typical database management systems, to an extent sufficient to select and utilize a DBMS to support real world applications.

BASIC CONCEPTS OF THE COURSE

1	Entity Relationship Model
2	Relational Schema
3	SQL
4	DDL, DML
5	Normal Forms
6	Query Optimization
7	Data Warehouse, Star Schema
8	OLTP and OLAP

COURSE OUTLINE

Week	Topics
1	Database system concepts and architecture
2	ER Modelling
3	SQL DDL
4	Functional Dependencies and Normalization
5	Advanced SQL Programming
6	Relational Algebra
7	Query Processing
8	Midterm
9	Query Optimization
10	Transaction Processing concepts
11	Concurrency control techniques
12	Database Recovery techniques
13	Parallel and Distributed Databases
14	Data warehousing and OLAP

Prerequisite(s):
Textbook(s):	Database System Concepts 7th Ed, Silberschatz, Korth and Sudarshan, 2020
Additional Literature:	Fundamentals of Database Systems 7th Ed by Elsmasri and Navathe, 2015
Laboratory Work:
Computer Usage:
Others:	No

COURSE LEARNING OUTCOMES

1	Understand and apply the relational design techniques for databases, including ER and Normalization
2	Integrate a database management system with a general purpose programming environment to create an effective database application
3	Understand and use the query optimization techniques based on relational algebra
4	Understand and use the transaction and concurrency control techniques for high load databases
5	Understand the different query processing techniques for distributed and parallel databases

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

No	Program Competencies	Cont.
Master of Science in Computer Engineering (2 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.	5
7	The abilities and performance to participate multi-disciplinary groups together with the effective oral and official communication skills and personal confidence.	5
8	Ability for effective oral and official communication skills in foreign language.	4
9	Engineering graduates with motivation to life-long learning and having known significance of continuous education beyond undergraduate studies for science and technology.	4
10	Engineering graduates with well-structured responsibilities in profession and ethics.	5
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.	5
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.	5

COURSE EVALUATION METHOD

Method	Quantity	Percentage
Project	1	40
Final Exam	1	60
	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	5	80
Hours for off-the-classroom study (Pre-study, practice)	16	2	32
Mid-terms	1	15	15
Assignments	1	36	36
Final examination	1	25	25
Other			0
Total Work Load:			188
Total Work Load/25(h):			7.52
ECTS Credit of the Course:			7.5

CONCLUDING REMARKS BY THE COURSE LECTURER

-