Course Information Semester Course Code Course Title T+P+L Credit ECTS 2 03820102 Database Management 4+1+1 7 7 Course Details Language : Turkish Level : Associate Degree Department / Program : Computer Programming Mode of Delivery : Face to Face Type : Compulsory Objectives : Understanding database modeling, querying, and management techniques. Content : Conceptual Design with ER/UML Modelling; Relational Model; Relational Algebra; SQL; DB Integrity Programming Techniques (Assertions, Triggers); DB-driven Programming Languages (Stored Procedures, Embedded SQL, JDBC); Normalization;Physical Design Methods & Techniques : Prerequisites and co-requisities : None Course Coordinator : Instructor Seda YILDIRIM Name of Lecturers : Instructor Muhammed Saadetdin KAYA Assistants : None Work Placement(s) : No Recommended or Required Reading Resources : Database System Concepts Seventh Edition Avi Silberschatz Henry F. Korth S. SudarshanVeri tabanı Sistemleri, Ünal Yarımağan, Akademi Kitapevi Semester : Database System Concepts Seventh Edition Avi Silberschatz Henry F. Korth S. SudarshanVeri tabanı Sistemleri, Ünal Yarımağan, Akademi Kitapevi Course Category Mathematics and Basic Sciences 0% Engineering 30% Engineering Design 30% Social Sciences 0% Education 0% Science 0% Health 0% Field 40% In-Term Study Informations In-Term Studies Quantity Percentage Mid-terms 1 30% Final examination 1 70% Total 2 100% Activity Informations Activities Quantity Duration Total Work Load Course Duration 14 4 56 Hours for off-the-c.r.stud 14 2 28 Assignments 14 1 14 Mid-terms 1 3 3 Practice 14 4 56 Laboratory 14 3 42 Final examination 1 3 3 Total Work Load ECTS: 7 202 Course Learning Outcomes Upon the successful completion of this course, students will be able to: No Learning Outcomes 1 The student is able to design and model medium-scale databases. 2 The Student is able to criticize the database design issues and how to write basic SQL queries. 3 The student is able to use database management tools in the laboratory environment. 4 The student is able to design and program database-driven programs. 5 The student is able to apply new generation DB modelling/programming languages. Weekly Detailed Course Contents Week Topics 1 Introduction to fundementals of database concepts and main architecture of db systems. 2 Introduction to the Relational Model 3 Intro to SQL 4 Intermediate SQL 5 Advanced SQL 6 Advanced SQL 7 Advanced SQL 8 Midterm 1 9 DB design- ER 10 DB design- EER 11 Normalization 12 Normalization 13 Normalization 14 Real life DB applications 15 Final Exam Contribution of Learning Outcomes to Programme Outcomes P1P2P3P4P5P6P7P8P9P10P11P12P13P14P15P16P17P18 All C1 C2 C3 C4 bbb
