|
|
| 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 | | | Contact Hours | 14 weeks - 2 hours of lectures per week | | Lecturer | -- | | 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 - 1 : | Make database design according to the results of the requirement analysis. | 1.1 - 1.2 - 1.3 - 2.1 - 2.2 | 1,6, | | LO - 2 : | Evolve the skills of verbal and oral communication. | 4.1 - 4.2 | 1,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 | | |
| 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 | Complex queries in SQL | | | Week 9 | Midterm exam | | | 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 | 9 | | 1.25 | 20 | | Project | 15 | | 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 | | Proje | 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 |
|