Database Systems (ETF RIO BP 4770) |
|
General information |
|
Module title | Database Systems |
Module code | ETF RIO BP 4770 |
Study | ETF-B |
Department | Computing and Informatics |
Year | 1 |
Semester | 1 |
Module type | Mandatory |
ECTS | 7 |
Hours | 70 |
Lectures | 35 |
Exercises | 35 |
Tutorials | 0 |
Module goal - Knowledge and skill to be achieved by students |
|
| 1. Database systems physical level organization (storage hierarchy, memory management, page and buffer management, file types). <br> 2. Database index management and realization. <br> 3. Query elaboration. <br> 4. Query processing and optimization. <br> 5. Transaction management (concurrency control and management, synchronization, recovery and adjustment) <br> 6. Error protection. Security and authorization. <br> 7. Database system optimization. <br> 8. Database system architectures and versions (variations). <br> 9. Architecture - Data Warehouses. <br> 10. Object-oriented database system concepts. <br> 11. Basic principles of standard database interfaces (API) - JDBC. <br> 12. Database framework basics. <br> 13. Applications. <br> |
|
Syllabus |
|
Literature |
|
| Recommended | 1. Notes and slides from lectures (See Faculty WEB Site) |
| Additional | 1. Ramez Elmasri, Shamkant B. Navathe [2000], Fundamentals of Database Systems, Addison-Wesley, 2000. <br> 2. H.Garcia-Molina, J. D. Ullman, J. D. Widom: Database Systems: The Complete Book, Prentice-Hall, 2001 <br> 3.A. Silberschatz, H. F. Korth, S. Sundarshan: Database System Concepts, McGrow-Hill, 2001 <br> 4. Dž. Riđanović, B. Zaćiragić, V. Okanović: Korištenje baza podataka u Java programskom jeziku, TDP d.o.o. Sarajevo, 2005 <br> 5. B. Zaćiragić: Baze podataka (script) <br> |
Didactic methods |
|
| Through lectures, students will learn about the theory, tasks and applicative examples within thematic units. Lectures consist of theoretical part, presentational descriptive examples, genesis and resolution of specific tasks. In this way, students will have basis for appliance of skilled material in engineering applications. Additional examples and exam tasks are discussed and solved during the laboratory exercises. Laboratory practice and home assignments will enable students of continuous work and their knowledge verification. | |
Exams |
|
| During the course students will collect points according to the following system: <br> - Attending lectures, exercises and tutorial classes: 10 points, student with more then three absences from lectures, exercises and/or tutorials can not achieve these points; <br> - Home assignments: maximum of 10 points, assuming solving 5 to 10 assignments evenly distributed throughout the semester; <br> - Partial exams: two written partial exams, maximum of 20 points for each positively evaluated partial exam; <br> Student who during the semester achieved less than 20 points must re-enroll this course. <br> Student who during the semester achieved 40 or more points will access to final oral exam, the exam consists of discussing the partial exams tasks, home assignments and answers to simple questions related to course topics. <br> Final oral exam provides maximum of 40 points. To achieve a positive final grade, students in this exam must achieve a minimum of 20 points. Students who do not achieve this minimum will access to makeup oral exam. <br> Student who during the semester achieved 20 or more points, and less than 40 points will access to makeup exam. Makeup exam is structured as follows: <br> - Written part structured in the same way as a partial written exam, during which students solve problems in topics they failed on partial exams (achieved less then 10 points), <br> - Oral part structured in the same way as a final oral exam. <br> Only students who, after passing the written part of the makeup exam managed to achieve a total score of 40 or more points, can access to oral makeup exam, where the score consists of points achieved through attending classes, home assignments, passing partial exams and passing the written part of makeup exam. <br> Oral makeup exam provides maximum of 40 points. To achieve a positive final grade, students in this exam must achieve a minimum of 20 points. Students who do not achieve this minimum must re-enroll this course. <br> |
|
Aditional notes |
|