Example Problem in Designing Schema

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

Problems:

- redundancy

- update anomalies

- deletion anomalies

Previous slide

Next slide

Back to first slide

View graphic version