Learning Objectives:
Students acquire the skills to,
- be able to transform a UML class diagram into a relational data model (both manually and with a CASE tool) and understand ER models
- be able to implement a database schema using SQL-DDL and insert, query and modify data using SQL-DML
- be able to implement integrity conditions with the help of constraints
- be able to apply database rights concepts in practice
- be able to implement database application logic in an application program and with the help of an OR mapper
- Know the concepts of transaction management and database index structures and be able to apply them appropriately
- Know basic concepts of NoSQL database systems
Course content:
- Conceptual data modeling based on the UML class diagram and the ER model
- Relational data modeling
- SQL-DDL, SQL-DML, system catalog
- Accessing databases from an application
- Use of OR mappers
- Transaction concept
- Internal data organization: indexes (B-trees, hash methods)
- NoSQL databases
