19E112BP - Databases

Course specification
Course title Databases
Acronym 19E112BP
Study programme Electrical Engineering and Computing
Module Telecommunications and Information Technologies
Type of study bachelor academic studies
Lecturer (for classes)
    Lecturer/Associate (for practice)
      Lecturer/Associate (for OTC)
        ESPB 4.0 Status elective
        Condition None
        The goal 1. Introduce students to fundamentals and principles of DBMS. 2. Introduce the database design concepts. 3. Provide students with the ability to design and implement concrete data base and use commercially available DBMS.
        The outcome Students are capable to design and implement concrete data base and use commercially available DBMS.
        URL to the subject page
        URL to lectures
        Contents of lectures Fundamentals and Principles of DBMS. Data Abstraction. Instances and Schemes. Data Independence. Data Models. DDL, DML. Entity-Relationship Model. Relational Data Model. Relational Algebra & Calculus, SQL. Optimization of Relational Queries. Object-Oriented Database Systems. Object-Relational Database Systems.Transaction processing. Validation techniques. Crash recovery. Commercial Systems.
        Contents of exercises Laboratory exercises: Design and implementation of concrete data base using commercially available DBMS.
        1. Database System Concepts, A. Silberschatz, H. Korth, S Sudarshan, McGraw Hill Education, 2010. (Original title)
        2. Database Systems:The Complete Book, H. Garcia-Molina, J.D.Ulman, J. Widom, Prentice Hall, 2008. (Original title)
        3. Upravljanje Transakcijama, M.Bojovic, Akademska misao, 2003. (Original title)
        Number of hours per week during the semester/trimester/year
        Lectures Exercises OTC Study and Research Other classes
        3 1 1
        Methods of teaching 30 hours of lectures + 30 hours of supervised problem classes + 15 hours of supervised laboratory classes, midterm tests and project. Approximately 75 hours of personal study and exercise (3 hours per week during semester, and approximately 30 hours of preparation during exam term).
        Knowledge score (maximum points 100)
        Pre obligations Points Final exam Points
        Activites during lectures 0 Test paper 60
        Practical lessons 10 Oral examination 0
        Projects 10
        Colloquia 20
        Seminars 0