This class is HW3 review and normalization practice. I intend on spending it doing hw4. If there are no notes after this paragraph, you know why.
Class has voted for a 8.5x11 notes sheet during the written exam.
normal forms
1,2 -> 3,4,5,6,7,8,9,10,11
1->3,4,5,6,7
2->9,10,11
3,4->5,6
5->6
11->10
10->11
1,2 ->8
1->3,4,7
2->9,10
3,4->5
5->6
10->11
Underline is Primary Key
Dashed underline is Foreign Key
A(1, 2, → 8)
B(1 → 3, 4, 7)
C(2 → 9, 10)
D(3,4 → 5)
E(5 → 6)
F(10 → 11)
alas I have forgotten the MEI statements.
A(1) MEI B(1)
A(2) MEI C(2)
B(3) MEI D(3)
B(4) MEI D(4)
C(10) MEI F(10)
D(5) MEI E(5)
Boyce codd - All the determinants that we have, need to be a primary or candidate key in our proposed relations. Determinants: 1,2,3,4,5,10,11 - 11 isn’t a primary key, but it is a candidate key for relation F.