Normalisation

Normalisation
1 / 11
next
Slide 1: Slide
ComputingFurther Education (Key Stage 5)

This lesson contains 11 slides, with interactive quizzes and text slides.

time-iconLesson duration is: 50 min

Items in this lesson

Normalisation

Slide 1 - Slide

Normalisation

Slide 2 - Mind map

Normalisation
Normalization is the process of organizing the attributes and tables of a relational database to minimize redundancy and dependency. 

It involves dividing large tables into smaller tables and defining relationships between them.


There are several levels, which we call, "normal forms", each building upon the last, that are used to guide the normalization process.

Slide 3 - Slide

Primary keys
A
Must be unique within the table, but it can be made of multiple attributes.
B
Must be a single attribute and cannot contain null values.
C
Uniquely identifies a record within a table and can be duplicated in other tables.
D
Is optional and not required for relational databases.

Slide 4 - Quiz

Composite keys
A
Made up of multiple attributes, each of those must be unique in the table.
B
Always optional & not commonly used in relational databases.
C
Consist of a single attribute that uniquely identifies each record within the table.
D
Cannot be used as foreign keys in other tables.

Slide 5 - Quiz

Field name
A
A vertical arrangement of data in a database.
B
Location I put in the sat nav to find my pigs.
C
A record of data arranged into fields or columns.
D
A label, assigned to a data attribute in a table.

Slide 6 - Quiz

Redundancy
A
Inefficient for data storage, retrieval and maintainance.
B
Unneccesary duplication or repitition of data in a database.
C
Efficient for data storage, retrieval and maintainance.
D
Neccesary duplication or repitition of data in a database.

Slide 7 - Quiz

First Normal Form (1NF)
  • All field names must be unique.
  • Values in fields should be from the same domain or data type.
  • Values in fields should be atomic.
  • No two records can be identical.
  • Each table needs a primary key.
Normalise the table provided to 1NF

Slide 8 - Slide

Second Normal Form (2NF)
  • Must already be in 1NF.
  • Every non-key column should be dependent on the whole primary key, not just part of it.
  • Many to many relationships should be repaired. We can use a linking table to do this easily with the table's primary keys.

Normalise your table to 2NF

Slide 9 - Slide

Third Normal Form (3NF)
  • Must already be in 2NF.
  • No transitive dependencies should exist.
That means If any field doesn't rely on the primary key, it shouldn't be there


Normalise your table to 3NF

Slide 10 - Slide

DIY
Table for a sales company selling something of your choice
1: Put all the data which you think you'll need in one table.
2: 1NF
3: 2NF
4: 3NF

Slide 11 - Slide