‹Return to search

Third Normal Form

Normalising databases
1 / 7
next
Slide 1: Slide
Ilearningdeal@gmail.comSpecial Education

This lesson contains 7 slides, with interactive quizzes, text slides and 1 video.

Items in this lesson

Normalising databases

Slide 1 - Slide

4

Slide 2 - Video

00:31
What are the rules for 3rd Normal form?

Slide 3 - Open question

02:23
How would you check that a table was in 2nd Normal form

Slide 4 - Open question

03:41
Why is teacher ID and Teacher name translative dependency

Slide 5 - Open question

05:04
Why does the table violates 3rd Normal form?

Slide 6 - Mind map

Thank you!

Slide 7 - Slide

More lessons like this

Normalisation

- Lesson with 11 slides
ComputingFurther Education (Key Stage 5)

Normalisation

- Lesson with 11 slides
ComputingFurther Education (Key Stage 5)

Unit 2 -June 22

- Lesson with 22 slides
Ilearningdeal@gmail.comSpecial Education

Unit 2 - Paper 1 Activity 1

- Lesson with 25 slides
Ilearningdeal@gmail.comPrimary Education

Creating Tables

- Lesson with 12 slides
Ilearningdeal@gmail.comPrimary EducationLower Secondary (Key Stage 3)Upper Secondary (Key Stage 4)Further Education (Key Stage 5)Higher Education (degree)Higher Education (non-degree)Special EducationFoundation Degree

2nd 3rd conditional

- Lesson with 16 slides
EngelsMiddelbare schoolhavo, vwoLeerjaar 3

PAST SIMPLE - Irregular verb

- Lesson with 18 slides
EngelsMiddelbare schoolvmbo b, kLeerjaar 3

Unit 2 MUSIC

- Lesson with 19 slides
EngelsMiddelbare schoolvmbo k, g, tLeerjaar 1