Fichas
Week 4 - Normalisation
Fichas del conjunto (7)
- 1Data normalisation- Systematic series of steps for progressively refining the data model
- Formal approach to analysing relations based on their PK and functional dependencies
- Helps avoid data anomalies and redundancy - 2Types of dependencies- Full dependency - attribute is dependent on all attributes in the composite PK
- Partial dependency - attribute is dependent on only a subset of the PK
- Transitive dependency - attribute is dependent on another attribute that is not part of the PK
- Total dependency => attribute A determines B and attribute B determines A - 3Unnormalised form (UNF)- Raw representation mapped from inspection of the form
- Single named representation
- No PK has been identified - 4First normal form (1NF)- Identify PK (unique for each row)
- All attributes are functionally dependent on all or part of PK
- Valid relation => entity integrity, no repeating groups (multivalued attributes)
- Partial dependencies are noted in diagram - 5Second normal form (2NF)- All non-key attributes are fully functionally dependent on any CK (no partial dependencies)
- Transitive dependencies are noted in diagram - 6Third normal form (3NF)- No non-key attributes are dependent on another non-key attribute (no transitive dependencies)
- All dependencies are noted in diagram - 7Attribute synthesis- Join together relations, which have an identical PK
- Ensure attribute names are consistent
Información
- Descripción
- (FIT2094: Databases) Computer Science Fichas sobre Week 4 - Normalisation, creado por Melina Mackey el 01/11/2020.
- Creado por
- Melina Mackey
- Visitas
- 0
- Historial
-
- Creado por Melina Mackey · 19 oct 2020
- Copiado por Melina Mackey · 25 oct 2020
- Copiado por Melina Mackey · 1 nov 2020
- Valoración