Homework #
8 – Due
Submitted by : ________________________________________
1.Consider the relation:
PERSON_2 (Name, Sibling, Shoe_Size, Hobby)
Assume Name àà Sibling, Name à Shoe_Size, and Name àà Hobby. Describe deletion, modification, and insertion anomalies for this relation.
Using the data in Figure 3-18 and adding Shoe_Size, we get the following relation:
|
Name |
Sibling |
Shoe_Size |
Hobby |
|
Jones |
Fred |
E |
Model boats |
|
Jones |
Fred |
E |
Scuba Diving |
|
Jones |
Sally |
E |
Model boats |
|
Jones |
Sally |
E |
Scuba Diving |
|
Jones |
Frank |
E |
Model boats |
|
Jones |
Frank |
E |
Scuba Diving |
|
Greene |
Nikki |
B |
Embroidery |
|
Chau |
Jonathan |
C |
Scuba diving |
|
Chau |
Eileen |
C |
Scuba diving |
a. Deletion Anomaly
|
|
b. Modification Anomaly
|
|
c. Insertion Anomaly
|
|
d. How would you place the PERSON_2 relation into 4NF? (show the table(s)) and the key(s)
|
|
Page 97 in our text
A.1
|
|
A.3
|
|
A.5
|
|
page 114
problem 4.3 - try your answer and indicate which dbms (Access or SQL Server) it worked in.
|
|
problem 4.4
|
|