Relational Design Tasks 1

  • Watch videos (90 min) and answer questions from DB8 Relational Design Theory (https://class.stanford.edu/courses/DB/RD/SelfPaced/courseware/ch-relational_design_theory/)
    • Relational Design Overview (6:18 + 5:38 + 3:23 + 0:49)
    • Functional Dependencies (7:31 + 3:59 + 12:55 + 1:51 + 1:40)
    • Boyce-Codd Normal Form (11:51 + 6:35 + 4:38)
    • Shortcomings of BCNF/4NF (12:01, with attention to BCNF references n particular)
  • Do Normalization Quiz questions that do NOT involve multivalued dependencies (i.e., do questions Q2, Q3, Q4, Q5 from the Normalization Quiz) (https://class.stanford.edu/courses/DB/RD/SelfPaced/courseware/ch-relational_design_theory/)
  • Optionally, read Chapter 3 of U/W