DB 1 Assignment 4 Walkthrough
0:00 Introduction
1:15 Question 1: Overview
1:48 Question 1: Dependency Diagram
6:20 Question 1: Synthesis
8:40 Question 1: Decomposition
13:38 Question 1: Additional Candidate Keys
14:26 Question 1: Are we in Second Normal Form?
15:57 Question 1: Normalizing to 2NF
18:46 Question 1: Are we in Third Normal Form?
19:42 Question 1: Normalizing to 3NF
22:20 Question 2: Dependency Diagram
26:00 Question 2: Synthesis
29:51 Question 2: Decomposition
36:20 Question 2: Are we in Second Normal Form?
38:30 Question 2: Normalizing to 2NF
41:15 Question 2: Are with in Third Normal Form?
42:43 Question 2: Normalizing to 3NF
44:33 Question 2: Resolving the BCNF violation
45:50 Question 3: Overview
47:40 Question 3: Synthesis
53:20 Question 3: Decomposition
1:00:58 Question 3: Are we in Second Normal Form?
1:03:28 Question 3: Normalizing to 2NF
1:07:40 Question 3: Are we in Third Normal Form?
#SQL #Normalization #Database