Example
What
are the dependencies?
SSN à
Name, City
What
are the keys?
{SSN, PhoneNumber}
Is
it in BCNF?
Westfield
908-555-1234
987-65-4321
Joe
Westfield
908-555-2121
987-65-4321
Joe
Seattle
206-555-6543
123-45-6789
Fred
Seattle
206-555-1234
123-45-6789
Fred
City
PhoneNumber
SSN
Name