Databases
Instructor: Драгољуб Крнета, PhD, Associate Professor
Acquiring basic knowledge about databases and systems for managing databases.
| Code : | О2018ИБПО |
|---|---|
| Status: | C |
| Semestar: | 6th |
| Number of classes per week: | 4+3 |
| ЕECTS: | 7 |
| Teachers: |
Драгољуб Крнета,
PhD Associate Professor Маријана Драгичевић, Senior Assistant |
| Prerequisites: | No prerequisites. |
| Learning Outcomes (gained knowledge): | Students will be able to examine data requirements, to design a database, to understand the architecture and database components, to use query languages to access database data, and to create an application for updating and displaying database data. |
| Subject Contents: | Theoretical classes: Introduction: Database management systems and data models. Entity-relationship model: Model concepts. Entity-relationship model: Limitations. Operations. Examples. Relational model. SQL: Structure. SQL: Limitations. SQL: Operations. Object databases. Object-relational model. Active databases. XML as a data model. Database Management System Features. Database Design: System and User Requirements Analysis. Conceptual modeling. Database design: Normalization of relations. Preparing for the exam. Practical classes: Database management systems and data models. Entity-relationship model: Creating simple models. Entity-relationship model: Creating complex models. Relational model: Relational algebra. Relational calculation. SQL: Structure. SQL: Limitations. SQL: Operations. SQL: Tasks. Object, object-relational, and active databases: Examples. XML as a data model. Database Management System Features. Database Design: System and User Requirements Analysis. Conceptual modeling. Database design: Normalization of relations. Preparing for the exam. |
| Teaching Methods and Learning Activities: | Lectures, seminar classes and practical exercises. |
| Literature: | Lazarević, B., Marjanović, Z., Aničić, N., & Babarogić, S. (2010). Databases. Belgrade: FON, Belgrade. Additional literature: Referenced at the end of each chapter of the textbook which represents the basic literature. |
| Types of Assessment for the subject: | Colloquium I (0-20 points); Colloquium II (0-20 points); Final exam (0-50 points); Attendance (2point); Class activities (seminar papers, discussions, case studies) (0-8 points) |
| Special Remarks for the subject: |