|
TBB5101 | Database Management Systems | 1+2+0 | ECTS:7.5 | Year / Semester | Spring Semester | Level of Course | Second Cycle | Status | Elective | Department | DEPARTMENT of BIOSTATISTICS and MEDICAL INFORMATICS | Prerequisites and co-requisites | None | Mode of Delivery | Face to face, Lab work , Practical | Contact Hours | 14 weeks - 1 hour of lectures and 2 hours of practicals per week | Lecturer | -- | Co-Lecturer | None | Language of instruction | Turkish | Professional practise ( internship ) | None | | The aim of the course: | Understanding database management systems, designing a database system and using SQL. |
Programme Outcomes | CTPO | TOA | Upon successful completion of the course, the students will be able to : | | | PO - 1 : | Understanding conceptual and physical database structure | 4,11,13 | 1,3 | PO - 2 : | Understanding database management systems | 4,11,13 | 1,3 | PO - 3 : | Using SQL | 4,11,13 | 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), PO : Learning Outcome | |
Database management, conceptual, logical, physical database, hierarchical, network, relational data models, normalization, functional relations, true nature data modelling, entity, relation layers, design of database, Query language, physical database, organisation of indexes, searching acording to key, data compression. |
|
Course Syllabus | Week | Subject | Related Notes / Files | Week 1 | Introduction to Databases | | Week 2 | Data Models | | Week 3 | Database Plan, Design and Admistration | | Week 4 | Entitiy Relationship Model | | Week 5 | Entitiy Relationship Model | | Week 6 | Normalization | | Week 7 | Normalization | | Week 8 | Mid-term exam | | Week 9 | Conseptual, Logical and Physcial Database Design | | Week 10 | Database Management Systems | | Week 11 | SQL | | Week 12 | SQL | | Week 13 | Advanced SQL | | Week 14 | Oracle PL/SQL | | Week 15 | Revision of General Topics | | Week 16 | End-of-term exam | | |
1 | Özkan Y. 2003; Veri Tabanı Sistemleri, Alfa Yayıncılık, İstanbul. | | |
1 | Connoly, T. 2002; Database systems : a practical approach to design, implementation, and management, Harlow, England : Addison-Wesley. | | 2 | http://www.oracle.com/technology/documentation/index.html | | |
Method of Assessment | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | Mid-term exam | 8 | 7/10/2013 | 1 | 30 | Homework/Assignment/Term-paper | 12 | 7/12/2013 | 1 | 20 | End-of-term exam | 16 | 7/01/2014 | 1 | 50 | |
Student Work Load and its Distribution | Type of work | Duration (hours pw) | No of weeks / Number of activity | Hours in total per term | Laboratuar çalışması | 1 | 13 | 13 | Ödev | 5 | 5 | 25 | Total work load | | | 38 |
|