|
BIL 309 | Database Management | 3+0+0 | ECTS:4 | 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 | -- | Co-Lecturer | None | Language of instruction | Turkish | Professional practise ( internship ) | None | | The aim of the course: | Show how to design and implement Database Management System. |
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. | 1,3 | 1,3 | LO - 2 : | understand the functions of database management system. | 1,8,9,11 | 1,3 | LO - 3 : | understand the database systems design and methodology. | 1,5,8 | 1,3 | LO - 4 : | understand current database system technologies | 9,11 | 1,3 | LO - 5 : | design and implement (web-based) database systems. | | 1,3 | 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: Relational Model, Schemas, SQL, Semistructured Model, XML | | Week 2 | Relational Algebra: Basic Operations, Algebra of Bags | | Week 3 | Introduction to SQL: Select-From-Where Statements, Multirelation Queries, Subqueries | | Week 4 | More SQL: Extended Relational Algebra, Outerjoins, Grouping/Aggregation, Insert/Delete/Update | | Week 5 | Constraints: Foreign Keys, Local and Global Constraints, Triggers | | Week 6 | Transactions, Views, Indexes: Controlling Concurrent Behavior, Virtual and Materialized Views,
Speeding Accesses to Data | | Week 7 | Real SQL Programming: Persistent Stored Modules (PSM), PL/SQL, Embedded SQL | | Week 8 | Mid-term exam | | Week 9 | Database-Connection Libraries: Call-Level Interface, Java Database Connectivity, PHP | | Week 10 | XML: Document Type Definitions, XML Schema | | Week 11 | Query Languages for XML: XPath, XQuery, XSLT | | Week 12 | Design Theory for Relational Databases: Functional Dependencies, Decompositions, Normal Forms | | Week 13 | Multivalued Dependencies: Fourth Normal Form, Reasoning About FD's + MVD's | | Week 14 | Entity-Relationship Model: E/R Diagrams, Weak Entity Sets, Converting E/R Diagrams to Relations | | Week 15 | SQL Authorization: Privileges, Grant and Revoke, Grant Diagrams | | Week 16 | End-of-term exam | | |
1 | Garcia-Molina, H., Ullman, J. D. and Widom, J. 2009; Database Systems: The Complete Book, Prentice-Hall, 2nd Edition, 1248 p. | | |
1 | Yarımağan, Ü. 2002; Veritabanı Sistemleri, Akademi-Türkiye Bilişim Vakfı, 1. Baskı, 362 p. | | |
Method of Assessment | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | Mid-term exam | 8 | 16/04/2010 | 2 | 30 | Quiz | 13 | 07/06/2009 | 1 | 20 | End-of-term exam | 17 | 17/06/2009 | 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 | 14 | 42 | Sınıf dışı çalışma | 2 | 14 | 28 | Arasınav için hazırlık | 10 | 1 | 10 | Arasınav | 2 | 1 | 2 | Kısa sınav | 1 | 1 | 1 | Dönem sonu sınavı için hazırlık | 12 | 1 | 12 | Dönem sonu sınavı | 2 | 1 | 2 | Total work load | | | 97 |
|