|
|
| Aim of Module | To enable students to build a data model and become familiar with the normalisation process. |
| Credits | 7 |
| Suggested Time | 70 student learning hours |
| Prescription Expiry Date | Nov 2002 |
| Topics | Highest Skill Level | Suggested Assessment Percentage | |
| 1 Data Modelling | A | 30 | |
| 2 Relational Data Analysis | A | 50 | |
| 3 Consolidate Entities | A | 20 | |
| 100 | |||
| LEARNING OUTCOMES The Student Will | ||
| A | 1 | Design a data model for a simple organisation. |
| A | 2 | Perform Relational Data Analysis resulting in data being expressed in third normal form. |
| A | 3 | Consolidate entities in the data model, removing redundancies. |
| 1 Data Modelling |
| > | Draw a Data Model including: | |
| - | Relationships between entity types | |
| - | Types of relationships in terms of cardinality, optionality, exclusivity and involution | |
| - | Attributes of entity types | |
| > | Explain the design of unique identifiers | |
| - | Including candidate keys, primary keys, composite keys, foreign keys. | |
| 2 Relational Data Analysis |
| > | Expressing information in unnormalised logical form and identifying keys. | |
| > | Converting the unnormalised data to first, second and third normal form, testing resulting relations at each stage. | |
| > | Define further normal forms. | |
| 3 Consolidate Entities |
| > | Comparison of 3NF relations against the data model; removal of redundant entity types and relationships, resulting in a Normalised Data Model. | |
| Note | ||
| > | Some authors refer to a data model as an entity relationship diagram and/or entity model. | |