This week’s topics
Relational Theory and Normalisation
- First to Boyce-Codd Normal Forms
- Functional dependency analysis
- Redundancy elimination
- Transaction integrity guarantees
- Learn Boyce-Codd Normal Form (BCNF)
- This Simple Table Exposes Weak Normal Forms Knowledge
- #01 - Relational Model & Algebra (CMU Intro to Database Systems)
What you will be able to do
- 1.1 Assess how relational database models and normalisation provide reliable and efficient databases.
Activity
Start with this week’s 3 videos, then: Seminar, guided reading and a short written task: assess how relational database models and normalisation provide reliable and efficient databases.
Study materials
Videos
- Learn Boyce-Codd Normal Form (BCNF) · YouTube · Decomplexify · 14 min · for registered students
- This Simple Table Exposes Weak Normal Forms Knowledge · YouTube · Decomplexify · 18 min · for registered students
- #01 - Relational Model & Algebra (CMU Intro to Database Systems) · YouTube · CMU Database Group · 75 min · for registered students
- CMU Database Systems - 05 Normal Forms (Fall 2017) · YouTube · CMU Database Group · 71 min · for registered students
- CMU Database Systems - 04 Functional Dependencies (Fall 2017) · YouTube · CMU Database Group · 74 min · for registered students
- #01 - Relational Model & Algebra (CMU Intro to Database Systems) · YouTube · CMU Database Group · 84 min · for registered students
- F2023 #01 - Relational Model & Algebra (CMU Intro to Database Systems) · YouTube · CMU Database Group · 77 min · for registered students
- 01 - Relational Model & Relational Algebra (CMU Intro to Database Systems / Fall 2022) · YouTube · CMU Database Group · 80 min · for registered students
- CMU Database Systems - 02 Relational Algebra (Fall 2017) · YouTube · CMU Database Group · 81 min · for registered students
- CMU Database Systems - 01 Course introduction & Relational Data Model (Fall 2017) · YouTube · CMU Database Group · 50 min · for registered students
- 01 - Course Introduction & Relational Model (CMU Intro to Database Systems / Fall 2021) · YouTube · CMU Database Group · 74 min · for registered students
Further resources
- MIT 6.830 Database Systems (Fall 2010), lecture notes · Reading · MIT OpenCourseWare, course · for registered students
- Readings in Database Systems ('Red Book', 5th ed., Bailis, Hellerstein & Stonebraker) · PDF · Other, textbook · for registered students
- Introduction to Computer Science, ch. 8: Data Management · PDF · OpenStax, textbook chapter; pp. 369–438 · for registered students
Materials marked “for registered students” open in the student portal, which is set up as soon as you receive final acceptance.
