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
Collegejaar2021
Periode
KW1-KW2  (06-09-2021 t/m 30-01-2022)
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 part A of the course, the students must do a 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 given in that week. 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 Accomplished or NotAccomplished (Voldaan, NietVoldaan).

The examination of part B of this course will be in terms of a regular exam (probably a digital exam) which is graded with a grade between 0 and 10.

Bijzonderheden
Please note: due to the large number of registrations and the complex interdependencies in the schedule, there are multiple computer sessions scheduled on Tuesdays and Wednesdays. You only need to attend one of these, suiting your schedule.
For the premaster schedules, only Tuesday sessions are suitable.
Verplicht materiaal
Studiemateriaal
Course materials will be provided 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