 | Study programme 2019-2020 | Français | |
 | Databases I | ||
Programme component of Bachelor's in Mathematics à la Faculty of Science |
| Students are asked to consult the ECTS course descriptions for each learning activity (AA) to know what assessment methods are planned for the end of Q3 |
|---|
| Code | Type | Head of UE | Department’s contact details | Teacher(s) |
|---|---|---|---|---|
| US-B2-SCMATH-013-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 | 40 | 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-100 | Databases I (part A) | 0 | 15 | 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
- Understand "elementary" mathematics profoundly
- Understand and use the naive set theory
- Give examples and counterexamples for definitions, properties, theorems, etc.
- Understand and produce strict mathematical reasoning
- Use mathematical vocabulary and formalism appropriately
- Make sense of formal expressions
- Solve new problems
- Abstract and manipulate theories and use these to solve problems
Learning Outcomes of UE
At the end of the course, the students will be able to:
Design a relational database model.
Issue queries against a relational database.
Understand the functioning of a relational database system.
Content of UE
The relational model.
Relational algebra.
Relational calculus.
SQL.
Normalization (3NF, BCNF, 4NF, 5NF).
Transaction management.
Prior Experience
Not applicable
Type of Assessment for UE in Q1
- Written examination
- Practical test
Q1 UE Assessment Comments
Written examination on the theory and written examination on SQL.
Weights: theory 80%, SQL 20%.
Type of Assessment for UE in Q3
- Written examination
- Practical Test
Q3 UE Assessment Comments
Written examination on the theory and written examination on SQL.
Weights: theory 80%, SQL 20%.
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-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 - Partie 1 - Bases de données I (2019-2020) - Jef Wijsen |
| S-INFO-100 | Travaux Pratiques - Travaux pratiques de Bases de données I (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 Reading
| AA | |
|---|---|
| S-INFO-005 | |
| S-INFO-100 | |
| S-INFO-101 |
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 |