 | Study programme 2021-2022 | Français | |
 | Databases I | ||
Programme component of Master's in Computer Science à la Faculty of Science |
| Code | Type | Head of UE | Department’s contact details | Teacher(s) |
|---|---|---|---|---|
| US-MC-SCINFO-039-M | Compulsory UE | WIJSEN Jef | S832 - Systèmes d'information |
|
| Language of instruction | Language of assessment | HT(*) | HTPE(*) | HTPS(*) | HR(*) | HD(*) | Credits | Weighting | Term |
|---|---|---|---|---|---|---|---|---|---|
| Français | 30 | 25 | 0 | 0 | 0 | 6 | 6.00 | 1st term |
| AA Code | Teaching Activity (AA) | HT(*) | HTPE(*) | HTPS(*) | HR(*) | HD(*) | Term | Weighting |
|---|---|---|---|---|---|---|---|---|
| S-INFO-005 | Databases I | 30 | 0 | 0 | 0 | 0 | Q1 | |
| S-INFO-101 | Databases I (part B) | 0 | 25 | 0 | 0 | 0 | Q1 |
| Programme component |
|---|
Objectives of Programme's Learning Outcomes
- Have acquired highly specialised and integrated knowledge and broad skills in the various disciplines of computer science, which come after those within the Bachelor's in computer science.
- Apply scientific methodology.
- Demonstrate thoroughness, independence, creativity, intellectual honesty, and ethical values.
Learning Outcomes of UE
Design a relational database model.
Issue queries against a relational database.
Understand the functioning of a relational database system.
Content of UE
The relational data model.
Relational algebra.
Relational calculus (DRC, TRC).
SQL.
Normalization (3NF, BCNF, 4NF, 5NF).
Transaction management.
Prior Experience
Not applicable
Type of Assessment for UE in Q1
- Presentation and/or works
- Written examination
Q1 UE Assessment Comments
Written examination on the theory.
Type of Assessment for UE in Q3
- Written examination
Q3 UE Assessment Comments
Written examination on the theory.
Type of Resit Assessment for UE in Q1 (BAB1)
- N/A
Q1 UE Resit Assessment Comments (BAB1)
Not applicable
Type of Teaching Activity/Activities
| AA | Type of Teaching Activity/Activities |
|---|---|
| S-INFO-005 |
|
| S-INFO-101 |
|
Mode of delivery
| AA | Mode of delivery |
|---|---|
| S-INFO-005 |
|
| S-INFO-101 |
|
Required Reading
| AA | |
|---|---|
| S-INFO-005 | |
| S-INFO-101 |
Required Learning Resources/Tools
| AA | Required Learning Resources/Tools |
|---|---|
| S-INFO-005 | Web site with course notes, slides, and past examinations. |
| S-INFO-101 | Not applicable |
Recommended Reading
| AA | |
|---|---|
| S-INFO-005 | |
| S-INFO-101 |
Recommended Learning Resources/Tools
| AA | Recommended Learning Resources/Tools |
|---|---|
| S-INFO-005 | Not applicable |
| S-INFO-101 | Not applicable |
Other Recommended Reading
| AA | Other Recommended Reading |
|---|---|
| S-INFO-005 | Serge Abiteboul, Richard Hull, Victor Vianu: Foundations of Databases. Addison-Wesley 1995, ISBN 0-201-53771-0 David Maier: The Theory of Relational Databases. Computer Science Press 1983, ISBN 0-914894-42-0 (both books are available online) |
| S-INFO-101 | Not applicable |