3. Define a generalization hierarchy containing the STUDENT entity, the UNDSTUDENT entity, and the GRADSTUDENT entity. The STUDENT entity is the supertype, and UNDSTUDENT and GRADSTUDENT are subtypes. The STUDENT entity has the attributes StdNo (primary key), StdName, StdGender, StdDOB (date of birth), StdEmail, and StdAdmitDate. The UNDSTUDENT entity has attributes UndMajor, UndMinor, and UndClass. The GRADSTUDENT entity type has attributes GradAdvisor, GradThesisTitle, and GradAsstStatus (assistantship status). The generalization hierarchy should be complete and disjoint. (10 points) Use the data model provided below to answer questions 4 to 6 . 4. List all the attributes of a movie (5 points) 5. Based on the data model, is it required that every entity instance in the PRODUCT table be associated with an entity instance in the CD table? Why, or why not? (5 points) 6. Is it possible for a book to appear in the BOOK table without appearing in the PRODUCT table? Why, or why not? (5 points) 3. Define a generalization hierarchy containing the STUDENT entity, the UNDSTUDENT entity, and the GRADSTUDENT entity. The STUDENT entity is the supertype, and UNDSTUDENT and GRADSTUDENT are subtypes. The STUDENT entity has the attributes StdNo (primary key), StdName, StdGender, StdDOB (date of birth), StdEmail, and StdAdmitDate. The UNDSTUDENT entity has attributes UndMajor, UndMinor, and UndClass. The GRADSTUDENT entity type has attributes GradAdvisor, GradThesisTitle, and GradAsstStatus (assistantship status). The generalization hierarchy should be complete and disjoint. (10 points) Use the data model provided below to answer questions 4 to 6 . 4. List all the attributes of a movie (5 points) 5. Based on the data model, is it required that every entity instance in the PRODUCT table be associated with an entity instance in the CD table? Why, or why not? (5 points) 6. Is it possible for a book to appear in the BOOK table without appearing in the PRODUCT table? Why, or why not? (5 points)