|
|
| YZM2017 | Database and Management | 2+2+0 | ECTS:5 | | Year / Semester | Fall Semester | | Level of Course | First Cycle | | Status | Compulsory | | Department | DEPARTMENT of SOFTWARE ENGINEERING | | Prerequisites and co-requisites | None | | Mode of Delivery | Face to face, Practical | | Contact Hours | 14 weeks - 2 hours of lectures and 2 hours of practicals per week | | Lecturer | Doç. Dr. Özcan ÖZYURT | | Co-Lecturer | | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | The aim of the course is to let the students to know and understand database concept, to learn the concepts of relational model, to learn and use SQL statements, to realize the conceptual modeling, to iterate the conceptual model to relational model using database modeling principles, to learn database normalization theory and its effect to database design, to learn and apply query processing, optimization and database tuning, to realize SQL Server and use it, to suplies data integrity, to learn index theory and management, to define trigger and use.
|
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | understand the fundamental concepts of database systems. | 3,8 | 1, | | LO - 2 : | understand the functions of database management system. | 3,8 | 1 | | LO - 3 : | understand the database systems design and methodology. | 3,8 | 1 | | LO - 4 : | understand current database system technologies | 3,8 | 1 | | LO - 5 : | setup, use and management of SQL Server. | 3,8 | 1 | | 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 of database, data models, relational data model, components and characteristics of relational data model, entity-relational model, entity-relational diagrams, transaction from e-r diagram to tables, normalization, tables and its characteristics, SQL Server software and its components, design and implementation physical database, data integrity, constraints, structured query language, simple queries, advanced queries, views, index theory and management, stored procedures, triggers, backup and back from backup. |
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | Database and its concepts and components | | | Week 2 | Data models, relational data model and its concepts | | | Week 3 | Entity-relational (E-R) model and transaction to tables | | | Week 4 | Normalization, fuctional dependencies | | | Week 5 | Structured query language (SQL), its structure | | | Week 6 | SQL Server software, its components and architecture, simple administrative tools | | | Week 7 | Pyscically database design and implementation, table design and specifications | | | Week 8 | Data integrity concepts and implementation | | | Week 9 | Mid-term Exam | | | Week 10 | Query applications | | | Week 11 | Advanced queries | | | Week 12 | Working with views
| | | Week 13 | Index theory and management | | | Week 14 | Stored procedures | | | Week 15 | Triggers | | | Week 16 | End-of-term exam | | | |
| 1 | Gözüdeli, Yaşar. 2014. SQL Server ve Veritabanı Programlama, Seçkin Yayınevi. | | | |
| 1 | Aslan, Bora. 2013. Veri tabanı ilkeleri ve yönetim sistemleri, Paradigma yayınları. | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 9 | 01/12/2023 | 2 | 50 | | End-of-term exam | 16 | 23/01/2024 | 2 | 50 | | |
| Student Work Load and its Distribution | | Type of work | Duration (hours pw) | No of weeks / Number of activity | Hours in total per term | | Yüz yüze eğitim | 4 | 8 | 32 | | Sınıf dışı çalışma | 2 | 14 | 28 | | Laboratuar çalışması | 4 | 6 | 24 | | Arasınav için hazırlık | 2 | 7 | 14 | | Arasınav | 1 | 1 | 1 | | Dönem sonu sınavı için hazırlık | 6 | 4 | 24 | | Dönem sonu sınavı | 2 | 1 | 2 | | Total work load | | | 125 |
|