COURSE INFORMATION Course Title: DATABASE MANAGEMENT SYSTEMS

Code	Course Type	Regular Semester	Theory	Practice	Lab	Credits	ECTS
CEN 252	B	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:	Mükremin Özkul
Second Lecturer(s) (name, surname, academic title/scientific degree, email address and signature) and Office Hours:	Ernaso Kërbizi
Teaching Assistant(s) and Office Hours:	NA
Language:	English
Compulsory/Elective:	Compulsory
Classroom and Meeting Time:
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:	The objective of this course is to provide an introduction to the design and use of database systems, as well as an appreciation of the key issues in building such systems, and working with multiple database systems.

COURSE OUTLINE

Week	Topics
1	Database Systems, Data Models
2	The Relational Database Model, Entity Relationship (ER) Modeling
3	Relational Database Constraints
4	Relational Database Constraints
5	Structured Query Language
6	Structured Query Language
7	Advanced SQL
8	Midterm
9	Advanced SQL
10	Advanced SQL
11	Relational Algebra
12	Relational Algebra
13	Normalization of Database Tables
14	Review Week

Prerequisite(s):	None
Textbook:	Fundamentals of Database Systems, PEARSON Database Systems: Design, Implementation, and Management, Cengage Learning
Other References:
Laboratory Work:	Yes
Computer Usage:	Yes
Others:	No

COURSE LEARNING OUTCOMES

1	To learn the concepts of a relational database systems
2	To be able to analyze database requirements and develop logically design database
3	To learn relational database modeling
4	To learn SQL to manipulate, update, and create a database

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.	2
2	Apply key theories to practical problems within the global business context.	4
3	Demonstrate ethical, social, and legal responsibilities in organizations.	1
4	Develop an open minded-attitude through continuous learning and team-work.	1
5	Integrate different skills and approaches to be used in decision making and data management.	4
6	Combine computer skills with managerial skills, in the analysis of large amounts of data.	4
7	Provide solutions to complex information technology problems.	3
8	Recognize, analyze, and suggest various types of information-communication systems/services that are encountered in everyday life and in the business world.	3

COURSE EVALUATION METHOD

Method	Quantity	Percentage
Midterm Exam(s)	1	30
Quiz	1	10
Laboratory	2	10
Final Exam	1	40
	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	32
Mid-terms	1	9	9
Assignments	5	2	10
Final examination	1	10	10
Other			0
Total Work Load:			125
Total Work Load/25(h):			5
ECTS Credit of the Course:			5