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	4
NAME OF LECTURER(S)	Professor Murat Paşa Uysal
LEARNING OUTCOMES OF THE COURSE UNIT	At the end of this course, the students; 1) To have knowledge and skills at the level of knowledge and comprehension about the basic concepts related to the database, 2) To see the database and Database Management System problems as a whole at the analysis level, to separate them into parts, to solve the problem parts. to find the similarities and differences between 3) Information about Information System Development Life Cycle Stages and Database Design Stages at the levels of knowledge, comprehension and application, and have skills, 4) To have knowledge and skills at the level of knowledge, comprehension and application about Relational Data Models and Data Transformations, 5) Knowledge about SQL, Data Definition Language, Data Manipulation Language and related commands, to have knowledge and skills at the level of comprehension and application, 6) To have knowledge and skills at cognitive levels of knowledge and comprehension about Relation Types, Keys, Limitations, 7) Having basic knowledge and skills about MySQL Database, using MySQL Workbench for solving database problems. design and develop applications, 8) Conducting a Database Design and Implementation Term Project for the solution of a business-related problem, required analysis, They will acquire the knowledge and skills to carry out the design and implementation processes, and to produce the required project outputs.
MODE OF DELIVERY	Face to face
PRE-REQUISITES OF THE COURSE	No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT	None
COURSE DEFINITION	The aim of this course is to acquire knowledge and skills related to database design stages, database applications, SQL commands and the installation of database management systems.
COURSE CONTENTS	WEEK TOPICS 1st Week 1. Introduction to the Course and Objectives, Basic Concepts, Database Approaches, Introduction to Database Management Systems 2nd Week 2. Information System Development Life Cycle Stages, Database Design Stages 3rd Week 3. Conceptual Design and Existence-Correlation Modeling, Introducing E-R Editors 4th Week 4. Relationship Types, Keys, Limitations 5th Week 5. Relational Data Models and Transformations 6th Week 6. Transformations of Asset Relation Sets 7th Week 7. Midterm Exam 8th Week 8. Physical Design, Modeling and Implementation, Introducing MySql Workbench 9th Week 9. Data Definition Language and SQL, Database Objects, Using with MySql Workbench 10th Week 10. Data Manipulation Language, SELECT, INSERT, UPDATE, DELETE Commands and Uses 11th Week 11. Data Manipulation Language: SELECT, LEFT JOIN, INNER JOIN, GROUP BY Commands and Uses 12th Week 12. Project Presentations and Evaluation 13th Week 13. Project Presentations and Evaluation 14th Week 14. Final Exam
RECOMENDED OR REQUIRED READING	1. Ders Sunumları ve Dağıtılan Dokümanlar, 2. Veri Tabanı Sistemleri, Ünal Yarımağan, Akademi Yayınevi, 2010. 3. Mannino, Michael V, Database Design, Application Development and Administration, McGraw-Hill, 2007. 4. Connolly, T.M. and Begg, C.E. Database Systems: A Practical Approach to Design, Implementation, and Management, addison-Wesley, 2005. 5. A. Silberschatz, H.F. Korth ve S. Sudarshan. Database Systems Concepts 6th Edition. McGraw Hill, 2010. 6. Elmasri and Navathe, Fundamentals of Database Systems, Sixth Edition, Pearson Education, 2010. 7. Raghu Ramakrishnan and Johannes Gehrke, ?Database Management Systems?, Third Edition, McGraw-Hill, 2002. 8. Çağıltay, N. E ve Tokdemir, G. Veritabanı Sistemleri Dersi: Teoriden Pratiğe. Seçkin Yayıncılık, Ankara, 2010.
PLANNED LEARNING ACTIVITIES AND TEACHING METHODS	Geleneksel ve Project Destekli Öğretim Yöntemi
ASSESSMENT METHODS AND CRITERIA	Quantity Percentage(%) Mid-term 1 40 Assignment 2 10 Project 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,5 1,5 Preparation for Quiz Individual or group work 14 1 14 Preparation for Final exam 1 22 22 Course hours 13 2 26 Preparation for Midterm exam 1 14 14 Laboratory (including preparation) 13 1 13 Final exam 1 1,5 1,5 Homework 2 20 40 Project 1 20 20 Total Workload 152 Total Workload / 30 5,06 ECTS Credits of the Course 4
LANGUAGE OF INSTRUCTION	Turkish
WORK PLACEMENT(S)	No