Table Relationships - Database Design for Mere Mortals - page 267

to people who are accustomed to working with spreadsheets.) For example, you could take
the S TUDENT ID field from the STUDENTS table and incorporate it within the CLASSES
table structure, creating as many copies of the field as you need to represent the maximum
number of students that could attend any class. Figure 10.17 shows the revised version of
the CLASSES table structure.
Figure 10.17. Incorporating S TUDENT ID fields within the CLASSES table structure
This structure is likely to be problematic, so you might try taking the C LASS ID field from
the CLASSES table and incorporating it within the STUDENTS table structure instead.
Figure 10.18 shows the revised version of the STUDENTS table structure.