 | Study programme 2019-2020 | Français | |
 | Databases I | ||
Programme component of Master's in Computer Science (Charleroi (Hor. décalé)) à 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-MC-INFO60-013-C | Compulsory UE | CREMER Samuël | S829 - Informatique théorique |
|
| Language of instruction | Language of assessment | HT(*) | HTPE(*) | HTPS(*) | HR(*) | HD(*) | Credits | Weighting | Term |
|---|---|---|---|---|---|---|---|---|---|
| Français | 30 | 15 | 0 | 0 | 0 | 8 | 8.00 | 2nd term |
| AA Code | Teaching Activity (AA) | HT(*) | HTPE(*) | HTPS(*) | HR(*) | HD(*) | Term | Weighting |
|---|---|---|---|---|---|---|---|---|
| S-INFO-049 | Databases I | 30 | 15 | 0 | 0 | 0 | Q2 | 100.00% |
| 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.
- Carry out development or innovation projects in IT.
- Apply, mobilise, articulate and promote the knowledge and skills acquired in order to contribute to the achievement of a development or innovation project.
- Master the complexity of such work and take into account the objectives and constraints which characterise it.
- Apply scientific methodology.
- Critically reflect on the impact of IT in general, and on the contribution to projects.
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.
- Identify the most suited database paradigm for a specific use case.
Content of UE
The course presents the basics theoretical aspects of database conception:
- Entity-relation diagram, conceptual model, logic model and physical model
- "Pure" query language: relational algebra, tuple relational calculus and domain relational calculus.
- The SQL query language.
- The normal form theory
- Indexing mechanisms
- Advanced functionalities (stored procedure, trigger, replication)
- Introduction to Big Data and NoSQL systems.
Prior Experience
Not applicable
Type of Assessment for UE in Q2
- Written examination
Q2 UE Assessment Comments
100% written examination.
Type of Assessment for UE in Q3
- Written examination
Q3 UE Assessment Comments
100% written examination.
Type of Teaching Activity/Activities
| AA | Type of Teaching Activity/Activities |
|---|---|
| S-INFO-049 |
|
Mode of delivery
| AA | Mode of delivery |
|---|---|
| S-INFO-049 |
|
Required Reading
| AA | |
|---|---|
| S-INFO-049 |
Required Learning Resources/Tools
| AA | Required Learning Resources/Tools |
|---|---|
| S-INFO-049 | Not applicable |
Recommended Reading
| AA | |
|---|---|
| S-INFO-049 |
Recommended Learning Resources/Tools
| AA | Recommended Learning Resources/Tools |
|---|---|
| S-INFO-049 | Not applicable |
Other Recommended Reading
| AA | Other Recommended Reading |
|---|---|
| S-INFO-049 | R. Elmasri and Shamkant B. Navathe. Fundamentals Of Database Systems. 6th edition. Pearson Education. |
Grade Deferrals of AAs from one year to the next
| AA | Grade Deferrals of AAs from one year to the next |
|---|---|
| S-INFO-049 | Authorized |