Let us reconsider our student example in Exercise 5.2 in which the only attributes of student are Student_number and name Now we have another entity called HIGH SCHOOL, which is going to be the high school from which the student graduated. For the HIGH SCHOOL entity, we will record the high school’s name and the location (meaning city and state). Draw the ER diagram using the Chen-like model. Follow the methodology and include all English descriptions of your diagrams. Map the ER diagram to a relational database.

Exercise 5.2

Suppose we reconsider our STUDENT example, and the only attributes of student are Student name and name. Let us suppose we have another entity called HIGH SCHOOL —the high school from which the student graduated. For the HIGH SCHOOL entity, we will record the high school name and the location (meaning city and state). Draw the ER diagram using the concise form. What would you name the relationship here? Write out the grammar for the relationship between the two entities.