Exercise 5.3

Suppose that a college had one dormitory with many rooms. The DORMITORY entity, which is actually a dormitory room entity since there is only one dorm, has the attributes room number and single/double(meaning that there are private rooms and double rooms). Let us suppose that the STUDENT entity in this case contains the attributes student number, student name, and home telephone number. Draw the ER diagram in the Chen-like model linking the two entities. Name your relationships. Write the grammar for the relationship between the two entities.