Suppose that a college had one dormitory with many rooms. The dormitory entity, which is a DORMITORY

Question:

Suppose that a college had one dormitory with many rooms. The dormitory entity, which is a DORMITORY ROOM entity since there is only one dorm, 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 and student name and home telephone number. Draw the ER diagram using the Chen-like model. Follow the methodology and include all English descriptions of your diagram. Map the ER diagram to a relational database.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database Design Using Entity Relationship Diagrams

ISBN: 9781032017181

3rd Edition

Authors: Sikha Saha Bagui, Richard Walsh Earp

Question Posted: