Complete the methodology by adding sample data to Figures 5.3, 5.5, and Exercises 5.1, 5.2, 5.3, and

Question:

Complete the methodology by adding sample data to Figures 5.3, 5.5, and Exercises 5.1, 5.2, 5.3, and 5.4.

FIGURE 5.3

Exercises 5.1

Draw an ER diagram (using the Chen-like model) for an entity called HOTEL and include no fewer than fIve attributes for the entity. Of the fIve attributes, include at least one composite attribute and one multivalued attribute.

Exercises 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.

Exercises 5.3

Suppose a college had one dormitory with many rooms. The DORMITORY entity, which is actually a “dormitory room” entity since there is only one dorm. Dormitory has the attributes room number and single/double (meaning there are private rooms and double rooms). Let us suppose the STUDENT entity in this case contains the attributes student number, student name, and 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.

Exercises 5.4

If we have two entities, a PLANE and a PILOT, and describe the relationship between the two entities as