NWI-IPC033
Information Modelling and Databases
Cursus informatieRooster
CursusNWI-IPC033
Studiepunten (ECTS)6
CategorieBA (Bachelor)
VoertaalEngels
Aangeboden doorRadboud Universiteit; Faculteit der Natuurwetenschappen, Wiskunde en Informatica; Informatica en Informatiekunde;
Docenten
VorigeVolgende 2
Coördinator
dr. P. van Bommel
Overige cursussen docent
Examinator
dr. P. van Bommel
Overige cursussen docent
Contactpersoon van de cursus
dr. P. van Bommel
Overige cursussen docent
Docent
dr. P. van Bommel
Overige cursussen docent
Docent
E.J. Gerritse, MSc
Overige cursussen docent
Collegejaar2020
Periode
KW1-KW2  (31-08-2020 t/m 24-01-2021)
Aanvangsblok
KW1
Onderwijsvorm
voltijd
Opmerking-
Inschrijven via OSIRISJa
Inschrijven voor bijvakkersJa
VoorinschrijvingNee
WachtlijstNee
Plaatsingsprocedure-
Cursusdoelen
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.

 

Inhoud
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.
Niveau
Bachelor level.
Voorkennis

Toetsinformatie

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.

Bijzonderheden

Verplicht materiaal
Sheets
Lecture slides are distributed via Brightspace.

Werkvormen
Cursus
AanwezigheidsplichtJa

Toetsen
Eerste deeltentamen
Weging1
ToetsvormPaper
GelegenhedenBlok KW1, Blok KW2

Tweede deeltentamen
Weging1
ToetsvormDigitale toets met CIRRUS
GelegenhedenBlok KW2, Blok KW3