TYPE OF COURSE UNIT	Compulsory Course
LEVEL OF COURSE UNIT	Master's Degree With Thesis
YEAR OF STUDY	-
SEMESTER	-
NUMBER OF ECTS CREDITS ALLOCATED	10
NAME OF LECTURER(S)	Associate Professor Mustafa Sert
LEARNING OUTCOMES OF THE COURSE UNIT	At the end of this course, the students; 1) Know relational data mode and integrity constraints. 2) Know and apply relational algebra and structured query language (SQL). 3) Know normal forms and apply to designs. 4) Describe multidimensional and Bitmap index structures. 5) Know query evaluation and optimization principles. 6) Describe transaction management principles. 7) Object-relational, object, and multidimensional data models.
MODE OF DELIVERY	Face to face
PRE-REQUISITES OF THE COURSE	No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT	None
COURSE DEFINITION	An Overview of Database Management Systems. Relational DB Model and Integrity Constraints. Relational Algebra. Structured Query Language (SQL). Design Theory for Relational DBs: FDs. Design Theory for Relational Databases:Normalization. Index Structures. Multidimensional and Bitmap Indexes. Query Evaluation and Optimization. Transaction Management; Object-Relational, Object-Oriented, and Multimedia Data Models.
COURSE CONTENTS	WEEK TOPICS 1st Week An Overview of Database Management Systems 2nd Week An Overview of Database Management Systems 3rd Week Relational DB Model and Integrity Constraints 4th Week Relational DB Model and Integrity Constraints 5th Week Relational Algebra 6th Week Structured Query Language (SQL) 7th Week Mid-term 8th Week Design Theory for Relational DBs: FDs 9th Week Design Theory for Relational Databases: Normalization 10th Week Index Structures 11th Week Multidimensional and Bitmap Indexes 12th Week Query Evaluation and Optimization 13th Week Transaction Management 14th Week Object-Relational, Object-Oriented, and Multimedia Data Models
RECOMENDED OR REQUIRED READING	1. Molina, H.G., Ullmani J.D., Widom, J., "Database Systems - The Complete Book", Prentice Hall, (2002).
PLANNED LEARNING ACTIVITIES AND TEACHING METHODS	Lecture,Questions/Answers,Presentation,Practice,Problem Solving,Project,Report Preparation
ASSESSMENT METHODS AND CRITERIA	Quantity Percentage(%) Mid-term 1 30 Assignment 1 15 Quiz 1 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 1 Preparation for Quiz Individual or group work Preparation for Final exam 1 40 40 Course hours 14 3 42 Preparation for Midterm exam 1 30 30 Laboratory (including preparation) Final exam 1 2 2 Homework 2 30 60 Presentation (including preperation) 2 70 140 Total Workload 315 Total Workload / 30 10,5 ECTS Credits of the Course 10
LANGUAGE OF INSTRUCTION	Turkish
WORK PLACEMENT(S)	No