52. OCR A Level (H446) SLR10 - 1.3 Normalisation to 3NF
ฝัง
- เผยแพร่เมื่อ 9 ก.ค. 2024
- OCR Specification Reference
A Level 1.3.2c
Why do we disable comments? We want to ensure these videos are always appropriate to use in the classroom. However, we value your feedback, and are happy to consider amendments due to inaccuracies. Please get in touch with us directly at: admin@craigndave.co.uk
For all our support resources please visit:
craigndave.org/
student.craigndave.org/
00:00 Intro
00:12 Normalisation to 3NF: Database Basics Recap- Removing Repeating/Redundant Data
01:20 Database Basics Recap- Relationships
01:40 Database Basics Recap- Primary Keys
02:10 Database Normalisation
03:13 Normalisation- 0NF (Flat File Before any Normalisation)
03:56 Normalisation- 1NF
09:23 Normalisation- 2NF
13:22 A Trick for Spotting When to Split a Table
15:16 Normalisation- 2NF Part 2
18:55 Normalisation- 3NF
23:36 Summary
24:24 Key Questions
24:44 Going Beyond the Specification
25:00 Database Normalisation
25:25 Higher Normal Forms
26:58 This is All too Much!
27:59 Outro