About information modelling:
- Use set theory to define the foundation of information models.
- Create information structures as part of an information model.
- Add integrity constraints to the information structure in order to obtain a complete information model.
- Use grammars to express information models and their instantiations.
- For a given information model, define path expressions and evaluate them.
- Add complex types to information models to have more abstraction.
- Basic transformation and equivalence of information models.
About databases:
- The underlying theory of databases in terms of set theory.
- Manipulation of databases in terms of queries with joins, subqueries, and grouping instruments.
- Definition of databases in terms of table creation and corresponding creation of views and indexes.
- Basic integrity rules for databases and their contents.
- Advanced database integrity considerations using domain constraints and table constraints.
- Control of databases based on granting and revoking privileges.
- Recursive database queries and processing of hierarchical databases.
|
|
|
In this course, we consider a number of aspects which are relevant for the entire systems life cycle. To be able to accurately model the system, it is essential to understand the domain under consideration, to specify the boundaries of the domain, to identify the relevant concepts in the domain and their relationships, and to specify the rules or constraints of the behaviour of those concepts. The results of this analysis are registered in a conceptual model, which allows for the communication with the domain expert.
After modelling the system, the data part is implemented in one ore more databases. This implementation is a continuation of the phase of information modelling. The final implementation of the database is not a conceptual model itself, because it describes all kinds of implementation-oriented aspects of the system. Here we focus in particular on the necessary database operations. We use the Structured Query Language (SQL) to specify those operations. However, we first begin with the underlying (mathematical) foundations. |
|
|
|
|
There will be two partial exams. Each exam will be 50% of the final grade. The first partial exam will be in October. In this exam, the first half of the course will be tested. The second partial exam will be in January. In this exam, the second part of the course will be tested. |
|
|