 | Study programme 2025-2026 | Français | |
 | Databases I | ||
Programme component of Bachelor's in Computer Science (MONS) (day schedule) à la Faculty of Science |
| Code | Type | Head of UE | Department’s contact details | Teacher(s) |
|---|---|---|---|---|
| US-B2-SCINFO-003-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 | 36 | 0 | 0 | 0 | 7 | 7.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-100 | Databases I (part A) | 0 | 15 | 0 | 0 | 0 | Q1 | |
| S-INFO-101 | Databases I (part B) | 0 | 21 | 0 | 0 | 0 | Q1 |
| Programme component |
|---|
Objectives of Programme's Learning Outcomes
- Understand the fundamentals of computer science
- Show an understanding and deep knowledge of the concepts of computer science and mathematical formalisms used in the field of computer science
- Solve exercises and computer problems by applying basic knowledge in the various disciplines of computer science
- Use the vocabulary and the correct mathematical reasoning to formulate and solve problems in the field of computer science
- Demonstrate basic knowledge and know-how in related fields
- Demonstrate knowledge and basic skills in science and technology.
- Manage IT projects
- Manage a project in compliance with specifications, constraints and deadlines
- Understand the fundamentals related to scientific methods
- Develop skills of abstraction and modelling through a conceptual and scientific approach
- Conduct rigorous reasoning based on scientific arguments
Learning Outcomes of UE
Design a relational database model.
Issue queries against a relational database.
Understand the functioning of a relational database system.
UE Content: description and pedagogical relevance
The relational data model.
Relational algebra.
Relational calculus (DRC, TRC).
SQL.
Normalization (3NF, BCNF, 4NF, 5NF).
Transaction management.
Prior Experience
Not applicable
Type(s) and mode(s) of Q1 UE assessment
- Written examination - Face-to-face
Q1 UE Assessment Comments
Written examination on the theory and written examination on SQL.
Weights: theory 80%, SQL 20%.
Method of calculating the overall mark for the Q1 UE assessment
Written examination on the theory and written examination on SQL.
Weights: theory 80%, SQL 20%.
Type(s) and mode(s) of Q1 UE resit assessment (BAB1)
- Written examination - Face-to-face
Q1 UE Resit Assessment Comments (BAB1)
Not applicable
Method of calculating the overall mark for the Q1 UE resit assessment
Written examination on the theory and written examination on SQL.
Weights: theory 80%, SQL 20%.
Type(s) and mode(s) of Q3 UE assessment
- Written examination - Face-to-face
Q3 UE Assessment Comments
Written examination on the theory and written examination on SQL.
Weights: theory 80%, SQL 20%.
Method of calculating the overall mark for the Q3 UE assessment
Written examination on the theory and written examination on SQL.
Weights: theory 80%, SQL 20%.
Type of Teaching Activity/Activities
| AA | Type of Teaching Activity/Activities |
|---|---|
| S-INFO-005 |
|
| S-INFO-100 |
|
| S-INFO-101 |
|
Mode of delivery
| AA | Mode of delivery |
|---|---|
| S-INFO-005 |
|
| S-INFO-100 |
|
| S-INFO-101 |
|
Required Reading
| AA | Required Reading |
|---|---|
| S-INFO-005 | Note de cours - Bases de données I - JOZEF WIJSEN |
| S-INFO-100 | Travaux Pratiques - Travaux Pratiques SQL - Alain Buys |
| 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-100 | Not applicable |
| S-INFO-101 | Not applicable |
Recommended Learning Resources/Tools
| AA | Recommended Learning Resources/Tools |
|---|---|
| S-INFO-005 | Not applicable |
| S-INFO-100 | www.mysql.org |
| 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-100 | Not applicable |
| S-INFO-101 | Not applicable |