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 and relational algebra.
- 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.
- Integrity rules for databases and their contents.
- Basic transactions and isolation levels
- Control of databases based on granting and revoking privileges.
|
|
In part A of 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 in part A, we focus in part B on the implementation of the system 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 begin part B with the underlying foundations in terms of relational algebra.
|
 |
|
|
|
|
During the course, the students must do an individual project in which they apply the theory. The project must result in a Project Report. Every week, a new step in the project must be made and the Project Report must be extended according to the instructions. After 7 weeks, part A of the course is finished and the students must upload the final PDF of their Project Report via an assignment in Brightspace. This is the examination of part A. It will be graded with Pass or Fail.
[Please note: this description for the test format for part B is as currently foreseen, but is to be confirmed at a later stage.]
In part B the students must continue with their project work. Again, they produce a Project Report and every week the Project Report must be extended according to the instructions. At the end of part B, this second Project Report will be the examination of part B which will be graded with Pass or Fail.
|
|
|