Answer #1, #2, and answer any one more question.

1In Tiny college ERD identify event type entities. Why are the FKs numbered in each entity but not PKs? 2Which two entities share two different relationships - name the relationships.

3In Tiny College ERD how can you find the name and email for all students who took any classes in the new AHB building. Describe in plain English.

4In Tiny College ERD how can you find what is the average GPA of students in courses offered by each school? Describe in plain English. In your opinion which school may have the highest average grade (not graded)

Make an actual user data table showing total of 5 sample enrollments related to two students and two courses based on ENROLL entity metadata (assume one of the students failed a class). For date use mm/dd/yyyy format.

5What is the difference between External Model, Conceptual Model, and Internal model? Explain.

Example for question 4:

Building.PNG