|
|
| BILB3005 | Database Management Systems | 4+0+0 | ECTS:5 | | Year / Semester | Fall Semester | | Level of Course | First Cycle | | Status | Compulsory | | Department | COMPUTER SCIENCE | | Prerequisites and co-requisites | None | | Mode of Delivery | | | Contact Hours | 14 weeks - 4 hours of lectures per week | | Lecturer | Dr. Öğr. Üyesi Uğur ŞEVİK | | Co-Lecturer | | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | The object of this course is to make students to learn Database Management accompanied by file processing and relational data models, query languages and basic relational operators. |
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | be able to create the Conceptual Model of the database | 1,7,9 | 1,6, | | LO - 2 : | be able to create the Logical Model of the database | 1,7,9 | 1,6, | | LO - 3 : | be able to create the Physical Model of the database | 1,7,9 | 1,6, | | LO - 4 : | be able to manage data with SQL commands | 1,7,9 | 1,6, | | CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome | | |
| Basic Concepts, Purpose of DataBase Organization, Database System Structure, and Data Models: Hyra, Network, query and object oriented database models. Data definition, data processing, query languages, SQL. Database design, logical, conceptual and physical models. Normalization. Database Interface and access methods. Database management, Operational necessity, safety integrity and database applications. |
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | Introduction to Database Systems | | | Week 2 | Relational database design | | | Week 3 | Requirements Analysis | | | Week 4 | Conceptual Model | | | Week 5 | Logical Model | | | Week 6 | Object-Oriented Conceptual Model | | | Week 7 | Physical Model | | | Week 8 | Normalization | | | Week 9 | Mid-term exam | | | Week 10 | Introduction to Structured Query Language (SQL) | | | Week 11 | Data Definition Language | | | Week 12 | Data Manipulation Language | | | Week 13 | Data Manipulation Language | | | Week 14 | Data Control Language | | | Week 15 | Views, Triggers | | | Week 16 | End-of-term exam | | | |
| 1 | Çağıltay N. E., Tokdemir G., 2010, Veritabanı Sistemleri Dersi (Teoriden Pratiğe), Seçkin Yayınları | | | |
| 1 | Nizam A., 2015, Veritabanı Teorisi ve Uygulamaları, Papatya Yayıncılık | | | 2 | Rajiv C., 2016, Database Management System (DBMS): A Practical Approach, 5th Edition, S. Chand Publishing | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 9 | 18.04.2024 | 1,5 saat | 30 | | Project | 15 | 30.05.2024 | | 20 | | End-of-term exam | 16 | 07.06.2024 | 1,5 saat | 50 | | |
| Student Work Load and its Distribution | | Type of work | Duration (hours pw) | No of weeks / Number of activity | Hours in total per term | | | | | |
|