Database Systems, photo: Gerd Altmann
The course aims at developing capabilities for the use of database systems as data design and data management tools. After successfully completing the course, students will be able to:
Definition of database and Database Management System (DBMS), Comparing DBMSs to filesystems of Operating Systems, Advantages of DBMSs, Architecture of DBMSs and levels of abstraction, Data models, Methodology of database design and implementation, The Entity-Relationship conceptual model (Entities, Relationships, Constraints), The Extended Entity Relationship conceptual model (Generalization, Specialization and related constraints), The relational model (relation, relation schema, instances/tuples, relational database schema, Domain constraints, Key constraints, Foreign key constraints, General purpose constraints), Logical database design using the relational model, Relational Algebra, The SQL language, The DDL subset of SQL, The DML subset of SQL, Queries in SQL.
Lectures (3 hours per week) and Laboratory Exercises (1 hour per week)
Activity |
Semester workload |
Lectures |
3*13=39 hours |
Lab exercises |
1*13=13 hours |
Team Project |
64 hours |
Individual quizzes, assignments and Self-study |
34 hours |
Total number of hours for the Course (25 hours of work-load per ECTS credit) |
150 hours (total student work-load) |
Evaluation criteria are available to students at eclass here.