What is LessonUp
Search
Channels
Log in
Register
‹
Return to search
Normalisation
Normalisation
1 / 11
next
Slide 1:
Slide
Computing
Further Education (Key Stage 5)
This lesson contains
11 slides
, with
interactive quizzes
and
text slides
.
Lesson duration is:
50 min
Start lesson
Save
Share
Print lesson
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
More lessons like this
Unraveling the First Normal Form
September 2024
- Lesson with
14 slides
Unraveling the First Normal Form
September 2024
- Lesson with
14 slides
Unraveling the First Normal Form
October 2023
- Lesson with
14 slides
Creating Tables
September 2024
- Lesson with
12 slides
Ilearningdeal@gmail.com
Primary Education
Lower Secondary (Key Stage 3)
Upper Secondary (Key Stage 4)
Further Education (Key Stage 5)
Higher Education (degree)
Higher Education (non-degree)
Special Education
Foundation Degree
Creating Tables
January 2024
- Lesson with
12 slides
Ilearningdeal@gmail.com
Primary Education
Lower Secondary (Key Stage 3)
Upper Secondary (Key Stage 4)
Further Education (Key Stage 5)
Higher Education (degree)
Higher Education (non-degree)
Special Education
Foundation Degree
Unit 2 - Paper 1 Activity 1
September 2024
- Lesson with
29 slides
Computing ICT
Further Education (Key Stage 5)
Unit 2 - Paper 1 Activity 1
September 2024
- Lesson with
25 slides
Ilearningdeal@gmail.com
Primary Education
Creating Tables
September 2024
- Lesson with
12 slides
Ilearningdeal@gmail.com
Primary Education
Lower Secondary (Key Stage 3)
Upper Secondary (Key Stage 4)
Further Education (Key Stage 5)
Higher Education (degree)
Higher Education (non-degree)
Special Education
Foundation Degree