Examine the hierarchy for the university EER diagram (Figure 3-10). As a student, you ar...

Explanation:

In the above university enhanced entity relationship diagram, the attributes for GRADUATE STUDENT sub type are listed below:

• The attribute names are,

o SSN

o Name

o Address

o Gender

o Date_Of_Birth

o Major_Department

o Test_Score

• From the above list,

o The Test_Score is an attribute of the GRADUATE STUDENT sub-type.

o Major_Department is an attribute of the “STUDENT” supertype.

o SSN is an identifier of the “PERSON” supertype and its corresponding subtype is “STUDENT” and then “STUDENT” subtype acts as the supertype for GRADUATE STUDENT subtype.

o NAME, ADDRESS, GENDER, and Date_Of_ Birth is an attribute of the super type of the “PERSON” and its corresponding subtype is “STUDENT” and then “STUDENT” subtype acts as the supertype for GRADUATE STUDENT subtype.

The attribute names with corresponding data value are given below:

• For attribute name, “SSN” corresponds to the data value as “332-14-2656”.

• For attribute name, “Name” corresponds to the data value as “JOHNY”.

• For attribute name, “Address” corresponds to the data value as “13 LAKE Dr. MEDFORD OR 95106”.

• For attribute name, “Gender” corresponds to the data value as “MALE”.

• For attribute name, “Date_Of_ Birth” corresponds to the data value as “JAN. 02, 1992”.

• For attribute name, “Major_Department” corresponds to the data value as “INFORMATION TECHNOLOGY”.

• For attribute name, “Test_Score” corresponds to the data value as “956”.