Problems 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