Example

Name SSN Phone Number

Fred 123-321-99 (201) 555-1234

Fred 123-321-99 (206) 572-4312

Joe 909-438-44 (908) 464-0028

Joe 909-438-44 (212) 555-4000

What are the dependencies?

What are the keys?

Is it in BCNF?

Previous slide

Next slide

Back to first slide

View graphic version