TYPE OF COURSE UNIT	Compulsory Course
LEVEL OF COURSE UNIT	Bachelor's Degree
YEAR OF STUDY	3
SEMESTER	Sixth Term (Spring)
NUMBER OF ECTS CREDITS ALLOCATED	7
NAME OF LECTURER(S)	Associate Professor Mustafa Sert
LEARNING OUTCOMES OF THE COURSE UNIT	At the end of this course, the students; 1) Describe general concepts and principles of relational database management systems. 2) Design logical database. 3) Design physical database 4) Interpret and apply Structured Query Language (SQL). 5) Write and interpret relational algebraic expressions. 6) Describe and apply normalization rules. 7) Know transaction management principles. 8) Know query evaluation principles.
MODE OF DELIVERY	Face to face
PRE-REQUISITES OF THE COURSE	No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT	None
COURSE DEFINITION	Database Management System Concepts and principles. Entity-relationship (ER) and enhanced ER models. Relational data model and integrity constraints. ER/EER to relational mapping. Relational algebra and calculus. Structured query language (SQL). Logical database design, functional dependency, and normalizations. Physical database design, basic file structures, hash and B+ indexing structures. Query evaluation and optimization. Transaction processing.
COURSE CONTENTS	WEEK TOPICS 1st Week Database Management System Concepts and principles 2nd Week Entity-relationship (ER) and enhanced ER models 3rd Week Relational data model and integrity constraints 4th Week ER/EER to relational mapping 5th Week Relational algebra and calculus 6th Week Structured query language (SQL) 7th Week Logical database design 8th Week Mid-term 9th Week Functional dependency and normalizations 10th Week Physical database design 11th Week Basic file structures 12th Week Hash and B+ indexing structures 13th Week Query evaluation and optimization 14th Week Transaction processing
RECOMENDED OR REQUIRED READING	1. Ramakrishnan, R., Gehrke, J., "Database Management Systems", ISBN: 0072465638, Mc-Graw Hill, (2003). 2. Elmasri, R., Navathe, S.B., "Fundamentals of Database Systems", ISBN: 032141506X, Addison-Wesley, (2007). 3. Molina, H. G., Ullman, J.D., Widom, J., "Database Systems: The Complete Book", Prentice-Hall, (2009).
PLANNED LEARNING ACTIVITIES AND TEACHING METHODS	Lecture,Questions/Answers,Problem Solving,Experiment,Project,Report Preparation,Presentation
ASSESSMENT METHODS AND CRITERIA	Quantity Percentage(%) Mid-term 1 30 Assignment 4 15 Quiz 4 15 Total(%) 60 Contribution of In-term Studies to Overall Grade(%) 60 Contribution of Final Examination to Overall Grade(%) 40 Total(%) 100
ECTS WORKLOAD	Activities Number Hours Workload Midterm exam 1 1,5 1,5 Preparation for Quiz Individual or group work Preparation for Final exam 1 20 20 Course hours 14 5 70 Preparation for Midterm exam 1 15 15 Laboratory (including preparation) 6 2 12 Final exam 1 1,5 1,5 Homework 2 50 100 Quiz 4 ,5 2 Total Workload 222 Total Workload / 30 7,4 ECTS Credits of the Course 7
LANGUAGE OF INSTRUCTION	Turkish
WORK PLACEMENT(S)	No