|
|
| HRT3025 | Land Management Practices in Protected Areas | 2+0+0 | ECTS:4 | | Year / Semester | Fall Semester | | Level of Course | First Cycle | | Status | Elective | | Department | DEPARTMENT of GEOMATICS ENGINEERING | | Prerequisites and co-requisites | None | | Mode of Delivery | Face to face | | Contact Hours | 14 weeks - 2 hours of lectures per week | | Lecturer | Arş. Gör. Fatih TERZİ | | Co-Lecturer | None | | 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 : | be knowledgeable about database management systems, data models, database design, relational algebra and query languages. | 28 | | | LO - 2 : | perform database design. | 29 | | | LO - 3 : | evolve the skills of verbal and oral communication. | 29 | | | LO - 4 : | use software of database management systems. | 29 | | | 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 structures and file structures; sequential and random access file structures. Indexed file structures. Data models; Conceptual data models, implementation (logical) and Physical data models. Entity-Relationship model. Entity, attribute, relationship concepts. Database Design; Conceptual design with Entity-Relationship model. Relational data model. Database design with relational model. Relational algebra and SQL. Project; Database design and application development in Microsoft Access DBMS. |
| |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | | | | | | | |
| Student Work Load and its Distribution | | Type of work | Duration (hours pw) | No of weeks / Number of activity | Hours in total per term | | | | | |
|