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?