Information Modelling and Databases
Course infoSchedule
Course moduleNWI-IPC033
Credits (ECTS)6
CategoryBA (Bachelor)
Language of instructionEnglish
Offered byRadboud University; Faculty of Science; Informatica en Informatiekunde;
PreviousNext 2
dr. P. van Bommel
Other course modules lecturer
dr. P. van Bommel
Other course modules lecturer
Contactperson for the course
dr. P. van Bommel
Other course modules lecturer
dr. P. van Bommel
Other course modules lecturer
E.J. Gerritse
Other course modules lecturer
Academic year2020
KW1-KW2  (31/08/2020 to 24/01/2021)
Starting block
Course mode
Registration using OSIRISYes
Course open to students from other facultiesYes
Waiting listNo
Placement procedure-
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.
Bachelor level.
Presumed foreknowledge

Test information

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.


Required materials
Lecture slides are distributed via Brightspace.

Instructional modes
Attendance MandatoryYes

Partial exam, part A
Test weight1
Test typePaper
OpportunitiesBlock KW1, Block KW2

Partial exam, part B
Test weight1
Test typeDigital exam with CIRRUS
OpportunitiesBlock KW2, Block KW3

PLEASE NOTE: The exact format for examination of part B is still to be determined.