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
Step by Step Answer:
Database Design Using Entity Relationship Diagrams
ISBN: 9781032017181
3rd Edition
Authors: Sikha Saha Bagui, Richard Walsh Earp