Multivalued Dependencies

Name SSN Phone Number Course

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

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

Fred 123-321-99 (206) 432-8954 CSE-444

Fred 123-321-99 (206) 432-8954 CSE-341

The multivalued dependencies are:

Name, SSN Phone Number

Name, SSN Course

4th Normal form: replace FD by MVD.