Fichas
Normalisation - OCR Computer Science A Level
Fichas del conjunto (5)
- 1What is Normalisation?> Process to ensure the best possible design for a relational database
> Ensures that
- No data is unnecessarily duplicated
- Data is consistent throughout the database (e.g., not conflicting entries in different tables)
- The structure of each table is flexible and allows entering as many or as few items as requied
- The structure allows for complex queries - 2What is First Normal Form?> All field (attribute) names must be unique
> Values in fields (attributes) should be from the same domain
> Values in fields (attributes) should be atomic, i.e., they are either updated in their entirety or not at all
> No two records may be identical
> Every table must have a primary key - 3What is Second Normal Form?> All the requirements of 1NF
plus:
> Remove any partial dependencies (i.e., none of the attributes depend on composite keys / only part of the primary key)
> Fix and Many-to-Many relationships as a result of removing partial dependencies - 4What is Third Normal Form?> All the requirements of 2NF (and 1NF)
plus:
> Remove any transistive dependencies (i.e., ensure that non-key fields are not dependent on eachother) - 5Why is Normalisation Important?> Data integrity (i.e., no data redundancy) is maintained, meaning there is no conflicting or unnecessary duplication of data
> Faster searching, due to smaller tables with fewer fields (also saving storage space)
> Records cannot be accidentally deleted in one-to-many relationships
Información
- Descripción
- A level (Databases and SQL) Computer Science Fichas sobre Normalisation - OCR Computer Science A Level, creado por Malachy Moran-Tun el 18/05/2022.
- Creado por
- Malachy Moran-Tun
- Visitas
- 10
- Historial
-
- Creado por Malachy Moran-Tun · 18 may 2022
- Copiado por Malachy Moran-Tun · 18 may 2022
- Valoración