1. Given the dependency diagram shown below for Summer's Animal Rescue", answer all parts of question 1.

1a.  List the primary key(s) 

 

 

 

1b. Identify each dependency type (partial, transitive, or full) for each relationship numbered with green numbers: 

 

1)__       ___    

 

2)__          _     

 

3)                     

 

4)                    

 

5)                

 

 

1c.  This dependency diagram show is in what normal form?  

 

 

1d. Even if all lines on the dependency diagram were shown with solid lines and not dashed, how do you know which are partial dependencies? 

 

How do you know which are transitive dependencies? 

Transcribed Image Text:

VOLUNTEER_ CODE -2- VOLUNTEER LNAME ADOPTION APPLICATION 1 ADOPT APPLICATION LINE 4 APP_DATE ADOPTER_LNAME ANIMAL_ID ANIMAL_TYPE VOLUNTEER_ CODE -2- VOLUNTEER LNAME ADOPTION APPLICATION 1 ADOPT APPLICATION LINE 4 APP_DATE ADOPTER_LNAME ANIMAL_ID ANIMAL_TYPE