Data Management DL (4431)
  
Coordinating lecturer :Prof. dr. Jan VAN DEN BUSSCHE 
  
Co-lecturer :dr. Jan DE SPIEGELEER 
 dr. larissa CAPOBIANCO SHIMOMURA 
  
Member of the teaching team :Prof. dr. Geert Jan BEX 
 De heer Sebastián BUGEDO BUGEDO 

Language of instruction : English
Credits: 5,0
  
Period: semester 1 (5sp)
  
2nd Chance Exam1: Yes
  
Final grade2: Numerical
 
Exam contract: not possible
 
Sequentiality
 
   No sequentiality

Prerequisites

Some initiation in programming is assumed, as provided by the course on Programming in Python which runs in parallel with this course.


Content
  1. What is a database system? What is a data model? What is a query language?
  2. Conceptual database design, the Entity-Relationship model
  3. Logical database design, the relational model, functional dependencies, Boyce-Codd normal form, inclusion dependencies
  4. Querying relational databases: relational algebra, SQL
  5. Graph databases


Organisational and teaching methods
Organisational methods  
Distance learning ✔  


Evaluation

Semester 1 (5,00sp)

Evaluation method
Written exam100 %
Open-book ✔

Second examination period

Evaluation second examination opportunity different from first examination opprt
No
 

Compulsory course material
 

Course notes, plus materials provided through Blackboard.


Learning outcomes
Master of Statistics and Data Science
  •  EC 

    • The student can handle scientific quantitative research questions, independently, effectively, creatively, and correctly using state-of-the-art design and analysis methodology and software.

     
  •  DC 

    • ... correctly using state-of-the-art software.

  •  EC 

    • The student is able to efficiently acquire, store and process data.

     
  •  DC 
    		• ... selecting and using the best data management options
 
  EC = learning outcomes      DC = partial outcomes      BC = evaluation criteria  
Offered inTolerance3
1st year Master Bioinformatics - distance learning J
1st year Master Biostatistics - distance learning J
1st year Master Data Science - distance learning N
1st year Master Quantitative Epidemiology - distance learning J



1   Education, Examination and Legal Position Regulations art.12.2, section 2.
2   Education, Examination and Legal Position Regulations art.15.1, section 3.
3   Education, Examination and Legal Position Regulations art.16.9, section 2.