Refer to Figure 8.7. Change Figure 8.7 to include the following information: One building can have a

Question:

Refer to Figure 8.7. Change Figure 8.7 to include the following information: One building can have a maximum of 99 students living in it. A student has to enroll in at least one class and can enroll in a maximum of five classes. A class has to enroll at least 5 students and can enroll a maximum of 35 students. An instructor may or may not teach a class and can teach up to three classes. A course must have one instructor teaching it, and only one instructor can teach a particular course. An instructor may or may not have an office and can have up to two offices. A building may or may not have an office and can have up to 15 offices. A course has to be offered in one classroom and can only be offered in one classroom.

FIGURE 8.7

image

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: