The course focuses on the application of a design approach for a relational database.
| On completion of the unit, the student will be capable of: | Classification level | Priority |
|---|---|---|
| Acquiring the principles of relational system design, administration of RDBMS through a study of implementation techniques of these systems so as to understand its functions and thus its optimal tuning in terms of response time. | 3. Apply | Essential |
| Percentage ratio of individual assessment | Percentage ratio of group assessment | ||||
|---|---|---|---|---|---|
| Written exam: | 0 | % | Project submission: | 100 | % |
| Individual oral exam: | 0 | % | Group presentation: | % | |
| Individual presentation: | 0 | % | Group practical exercise: | % | |
| Individual practical exercise: | 0 | % | Group report: | % | |
| Individual report: | 0 | % | |||
| Other(s): % | |||||
| Type of teaching activity | Content, sequencing and organisation |
|---|---|
| Course/ Practical course | Definition of an information system and presentation of the different data models and processing at conceptual, logical and physical levels (based on the Merise approach). - Presentation of a model unit/association and the application of a conception approach for such a model. - Functional dependencies, graphs and matrices of functional dependencies. During the first 4 sessions students will apply the concepts through exercises. Early on in the course they will be asked to think about a project, to be worked on in pairs, on a theme of their choice which will consist of designing an information system (more precisely, the design of an information system database. - Normalisation process: the different normal forms and application of the transformation approach in 3NF (or 3.5) - transition from unit/association model to relational system |