Consider the relation:
PERSON (Name, Sibling, Shoe_Size)
Assume Name àà Sibling and Name à Shoe_Size. Describe deletion, modification, and insertion anomalies for this relation.
Name |
Sibling |
Shoe_Size |
Jones |
Fred |
E |
Jones |
Sally |
E |
Jones |
Frank |
E |
Greene |
Nikki |
B |
Chau |
Jonathan |
C |
Chau |
Eileen |
C |
Deletion Anomaly:
Modification Anomaly:
Insertion Anomaly:
How would you put the PERSON relation into 4NF?