|
HRT2030 | Database Management Systems | 2+0+0 | ECTS:4 | Year / Semester | Spring Semester | Level of Course | First Cycle | Status | Elective | Department | DEPARTMENT of GEOMATICS ENGINEERING | Prerequisites and co-requisites | None | Mode of Delivery | Face to face, Lab work , Practical | Contact Hours | 14 weeks - 2 hours of lectures per week | Lecturer | Dr. Öğr. Üyesi Gülten KARA | Co-Lecturer | | Language of instruction | Turkish | Professional practise ( internship ) | None | | The aim of the course: | To establish an understanding on both the theory and practice on Database Management systems. |
Learning Outcomes | CTPO | TOA | Upon successful completion of the course, the students will be able to : | | | LO - 3 : | Evolve the skills of verbal and oral communication. | 3,6 | 1,4 | LO - 6 : | Make database design according to the results of the requirement analysis. | 3,6 | 1,4 | 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 | |
Database Management systems (DBMS) ; Fundamentals, DBMS architecture and DBMS functions. Database schema and instance. . Data models; Conceptual data models, implementation (logical) and Physical data models. Entity-Relationship model. Entity, and relationship concepts. Database Design; Conceptual design with Entity-Relationship model. Relational data model. Database design with relational model. Relational algebra and SQL. Term Project; Database design and application program development in Microsoft Access DBMS. |
|
Course Syllabus | Week | Subject | Related Notes / Files | Week 1 | An Introduction to Database management Systems (DBMS). | | Week 2 | Database Design with Entity-Relationship data model. | | Week 3 | Database Design with Relational data model. | | Week 4 | An introduction to Microsoft Access DBMS | | Week 5 | Term Project; Design of a cadastral database in MS Access | | Week 6 | Term Project; Design of a cadastral database in MS Access | | Week 7 | Structured Query Language (SQL) and Relational Algebra | | Week 8 | Midterm | | Week 9 | Complex queries in SQL | | Week 10 | Developing Application programs in MS Access-1 | | Week 11 | Developing Application programs in MS Access-2 | | Week 12 | Developing Application programs in MS Access-3 | | Week 13 | Developing Application programs in MS Access-4 | | Week 14 | Developing Application programs in MS Access-5 | | Week 15 | Lab exam of term project | | Week 16 | Final exam | | |
1 | Elmasry R. and Navathe, 2003; Fundamentals of Database management Systems, Fourth edition, Addison-Wesley, ISBN 0-321-12226-7. | | 2 | Dr. S. Sumathi, S. Esakkirajan, 2007; Fundamentals of Relational Database Management Systems, Studies in Computational Intelligence 47, Springer-Verlag Berlin Heidelberg, ISBN:9783540483977, 3-540-48397-7. | | |
Method of Assessment | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | Mid-term exam | 8 | | 1.25 | 20 | Practice | 15 | | 0.1 | 30 | End-of-term exam | 16 | | 1.5 | 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 | 2 | 14 | 28 | Sınıf dışı çalışma | 1 | 7 | 7 | Laboratuar çalışması | 1 | 5 | 5 | Arasınav için hazırlık | 2 | 7 | 14 | Arasınav | 1.3 | 1 | 1.3 | Ödev | 3 | 4 | 12 | Dönem sonu sınavı için hazırlık | 2 | 7 | 14 | Dönem sonu sınavı | 1.3 | 1 | 1.3 | Total work load | | | 82.6 |
|