(9845)
Coordinating lecturer:Prof. dr. Jan VAN DEN BUSSCHE 
Member of the teaching team:Prof. dr. Jan VAN DEN BUSSCHE 

Credits: 3,0
Study load hours: 81
Period: semester 1 (3sp)

Language of instruction: English
Exam contract: not possible

2nd Chance Exam1: Yes
Final grade2: Numerical
Tolerance3: See included in these programmes
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 dependencie
4.Querying relational databases: relational algebra, SQL


Compulsory course material
 

Course notes, plus materials provided through Blackboard.


Organisational and teaching methods
Organisational methods  
Distance learning ✔  


Evaluation

Semester 1 (3,00sp)

Evaluation method
Written exam100 %
Open-book ✔
Off campus online evaluation/exam✔
For the full evaluation/exam✔
Explanation (English)Yes

Second examination period

Evaluation second examination opportunity different from first examination opprt
No


Learning outcomes
  EC = learning outcomes      DC = partial outcomes      BC = evaluation criteria  
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
 
Included in these programmesTolerance3
1st year Master Statistics - Bioinformatics DL basis compulsory Y
1st year Master Statistics - Biostatistics DL basis compulsory Y
1st year Master Statistics - Data Science DL basis compulsory Y
1st year Master Statistics - Epidemiology DL basis compulsory Y



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.