COURSE INFORMATION Course Title: DATABASE MANAGEMENT SYSTEMS

Code	Course Type	Regular Semester	Theory	Practice	Lab	Credits	ECTS
CEN 252	A	4	2	0	2	3	5

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:	Migena Ceyhan , TBA
Second Lecturer(s) (name, surname, academic title/scientific degree, email address and signature) and Office Hours:	Xhoena Duro
Teaching Assistant(s) and Office Hours:	NA
Language:	English
Compulsory/Elective:	Compulsory
Classroom and Meeting Time:	TBA
Course Description:	Database design using entity-relationship model and relational data model, SQL (data definition and data manipulation languages), data integrity and integrity constraints, triggers, stored procedures, indexing and application development.
Course Objectives:	• CG1-Explain the role of databases and their impact in the organization • CG2-Design and use operational databases • CG3-Write queries using SQL • CG4-Design and use analytical databases

COURSE OUTLINE

Week	Topics
1	Introduction, Syllabus, Canvas, Course Schedule, Group Project
2	Introduction to Databases and Data Warehouses
3	Conceptual Design
4	Conceptual Design
5	Logical Design
6	Normalization
7	Normalization
8	SQL
9	Midterm
10	Referential Integrity
11	Data Warehousing
12	Data Warehousing
13	NoSQL Databases
14	Group Projects

Prerequisite(s):
Textbook:	Database Systems: Introduction to Databases and Data Warehouses by Nenad Jukic, Susan Vrbsky, and Svetlozar Nestorov; ISBN: 978-1-943153-18-3
Other References:
Laboratory Work:
Computer Usage:
Others:	No

COURSE LEARNING OUTCOMES

1	• CG1-Explain the role of databases and their impact in the organization
2	• CG2-Design and use operational databases
3	• CG3-Write queries using SQL
4	• CG4-Design and use analytical databases

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

No	Program Competencies	Cont.
Bachelor in Business Informatics (3 years) Program
1	Identify activities, tasks, and skills in management, marketing, accounting, finance, and economics.	5
2	Apply key theories to practical problems within the global business context.	5
3	Demonstrate ethical, social, and legal responsibilities in organizations.	3
4	Develop an open minded-attitude through continuous learning and team-work.	5
5	Integrate different skills and approaches to be used in decision making and data management.	5
6	Combine computer skills with managerial skills, in the analysis of large amounts of data.	5
7	Provide solutions to complex information technology problems.	2
8	Recognize, analyze, and suggest various types of information-communication systems/services that are encountered in everyday life and in the business world.	4

COURSE EVALUATION METHOD

Method	Quantity	Percentage
Homework	2	5
Midterm Exam(s)	1	45
Final Exam	1	45
	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	2.5	40
Mid-terms	1	2	2
Assignments	6	2.9	17.4
Final examination	1	2	2
Other			0
Total Work Load:			125.4
Total Work Load/25(h):			5.016
ECTS Credit of the Course:			5