Database Technology

Aim

The aim of this course is to give a thorough introduction to the theoretical and practical issues underlying the design and implementation of modern database systems. After the completion of the course you should be able to:

• explain and use important terminology in text-based information management in a correct way.
• design a data model using EER diagrams.
• design and use a relational database.
• explain the theory behind the relational model and how this affects good design of databases.
• explain which file structures in the database management system can be used to implement a database system.
• explain the basic principles for indexing a database.
• explain which problems can occur when several users use the database and solutions to this.
• explain how a database can guarantee persistence of data.

Content

• Principles for general database management systems: DBMS,
• Methods for database design and use. Datamodelling with ER,
• Relational databases, SQL and relational algebra
• Normalisation of relational databases
• Datastructures for databases, indexing
• Transactions and cncurrency
• Recovery of databases
• Exempels on how effective data management can support sustainable development through a scenario.