TYPE OF COURSE UNIT	Compulsory Course
LEVEL OF COURSE UNIT	Master's Degree With Thesis
YEAR OF STUDY	1
SEMESTER	First Term (Fall)
NUMBER OF ECTS CREDITS ALLOCATED	10
NAME OF LECTURER(S)	Professor Murat Paşa Uysal
LEARNING OUTCOMES OF THE COURSE UNIT	At the end of this course, the students; 1) will acquire skills and knowledge about the basic concepts of database 2) will acquire skills and knowledge about system development life cycle steps, database design phases at comprehension and application level 3) will acquire skills and knowledge about Relational Data Models and Data Transformations 4) will acquire skills and knowledge about SQL, Data Definition Language, Data Manipulation Language and commands 5) will acquire skills and knowledge about relation types, keys, constraints 6) To acquire skills and knowledge about analysing the problems of database management systems 7) will acquire skills and knowledge about MySql database 8) To acquire skills and knowledge about database project development 9) To acquire skills and knowledge about Data Management Body of Knowledge and related processes and knowledge areas
MODE OF DELIVERY	Face to face
PRE-REQUISITES OF THE COURSE	No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT
COURSE DEFINITION	DATA MANAGEMENT AND DATABASE MANAGEMENT SYSTEMS
COURSE CONTENTS	WEEK TOPICS 1st Week Basic Concepts, Information Systems, Database Approaches, IS Development Life Cycle 2nd Week Database Design Phases-Conceptual Design: Entity Relationship Model, Keys, Relation Types, Constraints 3rd Week Database Design Phases-Logical Design : Relations, Relational Models and Transformations 4th Week Database Design Phases-Physical Design: Modeling Objects 5th Week Database Design Phases-Physical Design: Creating Database Objects Using MySQL Database Management System and Tools 6th Week Using SELECT Statements 7th Week Using JOIN-UPDATE-DELETE-INSERT Statements 8th Week Midterm Exam 9th Week Advance Database Management System Concepts and Applications (Distributed, Multi Databases, Transaction Management) 10th Week Database Normalization and Its Tools and Techniques (1. NF, 2. NF ve 3. NF) 11th Week Presentation-1 of Students's Research Assigments and Evaluation (DAMA-DBBOK Guide) 12th Week Presentation-2 of Students's Research Assigments and Evaluation (DAMA-DBBOK Guide) 13th Week Presentation-1 of Students's Term Projects and Evaluation 14th Week Presentation-2 of Students's Term Projects and Evaluation 15th Week Final Exam and Research Reports
RECOMENDED OR REQUIRED READING	Course documents. Mannino, Michael V, Database Design, Application Development and Administration, McGraw-Hill, 2007. Connolly, T.M. and Begg, C.E. Database Systems: A Practical Approach to Design, Implementation, and Management, addison-Wesley, 2005. Silberschatz, H.F. Korth ve S. Sudarshan. Database Systems Concepts 6th Edition. McGraw Hill, 2010. Elmasri and Navathe, Fundamentals of Database Systems, Sixth Edition, Pearson Education, 2010. Raghu Ramakrishnan and Johannes Gehrke, ?Database Management Systems?, Third Edition, McGraw-Hill, 2002. MySQL Veritabanı İle İlgili Kaynaklar Veri Tabanı Sistemleri, Ünal Yarımağan, Akademi Yayınevi, 2010.
PLANNED LEARNING ACTIVITIES AND TEACHING METHODS	Project-supported and traditional teaching methods will be used in the course. It is aimed to develop the research skills of the students with research problems related to this field while scanning the national and international literature related to data management and database management systems,Lecture,Project,Presentation,Discussion
ASSESSMENT METHODS AND CRITERIA	Quantity Percentage(%) Mid-term 1 30 Assignment 1 10 Project 1 10 Presentation of Case Study 1 10 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 14 10 140 Preparation for Final exam 14 3 42 Course hours 13 3 39 Preparation for Midterm exam 8 3 24 Laboratory (including preparation) Final exam 1 1 1 Homework 1 40 40 Project Total Workload 287 Total Workload / 30 9,56 ECTS Credits of the Course 10
LANGUAGE OF INSTRUCTION	Turkish
WORK PLACEMENT(S)	No