TYPE OF COURSE UNIT	Compulsory Course
LEVEL OF COURSE UNIT	Bachelor's Degree
YEAR OF STUDY	2
SEMESTER	Fourth Term (Spring)
NUMBER OF ECTS CREDITS ALLOCATED	5
NAME OF LECTURER(S)	Associate Professor Nurcan Alkış Bayhan
LEARNING OUTCOMES OF THE COURSE UNIT	At the end of this course, the students; 1) Have a broad understanding of database concepts and database management system software 2) Have a high-level understanding of major DBMS components and their function 3) Be able to model an application?s data requirements using conceptual modeling tools like ER diagrams and design database schemas based on the conceptual model. 4) Be able to write SQL commands to create tables and indexes, insert/update/delete data, and query data in a relational DBMS. 5) Will be able to describe and develop Relational Algebra queries 6) Can identify problems related to database usage in business life and produce solutions.
MODE OF DELIVERY	Face to face
PRE-REQUISITES OF THE COURSE	No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT
COURSE DEFINITION	The aim of this course is to make students gain knowledge and experience about the importance, necessity, design and development of database management systems. In the course, students are given information about database concepts and database management system software, data modeling tools such as ER diagrams are introduced, SQL and relational algebra queries are explained.
COURSE CONTENTS	WEEK TOPICS 1st Week Introduction to Conceptual modeling (data, database, database management systems, database characteristics, database examples) 2nd Week Database System Concepts and Architecture 3rd Week Database modeling using the Entity-Relationship (ER) 4th Week Database modeling using the Extended Entity-Relationship (ER) 5th Week The Relational Data Model and Relational Database Constraints 6th Week ER-to-Relational Mapping 7th Week EER to Relational Mapping 8th Week Midterm 9th Week Relational Algebra 10th Week Introduction to SQL 11th Week SQL 12th Week Functional Dependencies and Normalization for Relational Databases 13th Week Relational Database Design Algorithms and Further Dependencies 14th Week Transaction Processing Concepts and Theory
RECOMENDED OR REQUIRED READING	R. Elmasri, S.B. Navathe, Fundamentals of Database Systems, 4th edition, Addison-Wesley, 2004. Raghu Ramakrishnan, Database Management Systems, McGraw Hill, 3rd edition, 2003.
PLANNED LEARNING ACTIVITIES AND TEACHING METHODS	Presentation,Lecture,Discussion,Problem Solving
ASSESSMENT METHODS AND CRITERIA	Quantity Percentage(%) Mid-term 1 30 Project 1 30 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 2,5 2,5 Preparation for Quiz Individual or group work 14 3 42 Preparation for Final exam 1 25 25 Course hours 14 3 42 Preparation for Midterm exam 1 20 20 Laboratory (including preparation) Final exam 1 2,5 2,5 Homework Project 1 15 15 Total Workload 149 Total Workload / 30 4,96 ECTS Credits of the Course 5
LANGUAGE OF INSTRUCTION	Turkish
WORK PLACEMENT(S)	No