|
|
| COM3001 | Database Management | 3+0+0 | ECTS:5 | | Year / Semester | Fall Semester | | Level of Course | First Cycle | | Status | Compulsory | | Department | DEPARTMENT of COMPUTER ENGINEERING | | Prerequisites and co-requisites | None | | Mode of Delivery | Face to face | | Contact Hours | 14 weeks - 3 hours of lectures per week | | Lecturer | Prof. Dr. Güzin ULUTAŞ | | Co-Lecturer | None | | Language of instruction | | | Professional practise ( internship ) | None | | | | The aim of the course: | | Design and implementation of Databases using Database Management Systems. |
| 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. | 2,3,4,12 | 1 | | LO - 2 : | understand the functions of database management system. | 2,3,4,12 | 1 | | LO - 3 : | understand the database systems design and methodology. | 2,3,4,12 | 1 | | LO - 4 : | understand current database system technologies | 2,3,4,12 | 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 | | |
| Introduction to DBMS, conceptual logical and physical DBs, Data Modeling for a DB. Mapping between views. Structure of a DBMS. Network Data Model, ERD model, normalization, redundancy, functional dependence, Hierarchical Model. The Relational Model. DB Design. DB Security, Integrity and Control. Database Design, query languages, index management, keyword search, data compression. |
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | Introduction to Databases, Traditional File-Based Systems, Database approach, Roles in Database Environment. | | | Week 2 | Database Environment, the three level anti sparc architecture, Database Languages, Data models and conceptual modelling, Functions of a DBMS, componenents of a DBMS, Multi user DBMS architectures | | | Week 3 | Relational Model, Relational data structures, database relations, Relational keys, Representing relational database schemas, Integrity constraints, Views, | | | Week 4 | Relational algebra and relational calculus, unary operations, set operations, Join operations, division operation, aggregation and grouping operators | | | Week 5 | SQL: data manipulation, query by examples | | | Week 6 | SQL: data definition, query by examples | | | Week 7 | Database plannig, design and administration, Entity relationship modelling, entity types, relationship types, attributes, strong and weak entity types, structural constraints | | | Week 8 | Enhanced entity relationship modelling, specialization and generalization, aggregation, composition | | | Week 9 | Midterm Exam | | | Week 10 | Normalization, the purpose of normalization, data redundancy and update anomalies, functional dependencies, the process of normalization, 1NF, 2NF, 3NF | | | Week 11 | Advanced Normalization, More on Functional Dependencies, Boyce Codd Normal Form, fourt Normal Form, Fifth Normal Form | | | Week 12 | Conceptual Database Design, Logical database design, physical database design | | | Week 13 | Database security, Transaction management, concurrency control, database recovery, advanced transaction models
| | | Week 14 | Query Processing, cost estimation for the relational algebra operations, enumaretion of alternative execution strategies | | | Week 15 | Distributed databases, concept and design | | | Week 16 | Final exam | | | |
| 1 | Connolly Thomas, Carolyn Begg, Addison Wesley, Fourth Edition, Database Systems: A practical approach to design, implementation and management | | | |
| 1 | Ramakrishan, Raghu, Gehrke, Johannes, Database Management Systems | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 9 | 14/11/2019 | 1,45 | 25 | | Project | 14 | 23/12/2019 | 2 | 25 | | End-of-term exam | 16 | 30/12/2019 | 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 | 3 | 15 | 45 | | Sınıf dışı çalışma | 2 | 15 | 30 | | Arasınav için hazırlık | 8 | 1 | 8 | | Arasınav | 1 | 1 | 1 | | Proje | 1 | 15 | 15 | | Dönem sonu sınavı için hazırlık | 16 | 1 | 16 | | Dönem sonu sınavı | 2 | 1 | 2 | | Diğer 1 | 0 | 0 | 0 | | Diğer 2 | 0 | 0 | 0 | | Total work load | | | 117 |
|