March 2022
Intermediate to advanced
682 pages
22h 58m
English
Consider the following relation

The NewClass relation provides information about the students enrolled in classes and the faculty assigned to teach each class. An instance of this relation appears in FIGURE 6.1. In this example, we will assume that there is only one faculty member for each class (i.e., no team teaching). We also assume each class is always scheduled for the same room. Notice that because the NewClass table repeats the schedule and room information for every student enrolled in a class, there is duplication of information. Not only does this repetition take up additional storage space ...
Read now
Unlock full access