The best approach for the engineer to establish a one-to-many relationship between Major and Class records in a database is: b.) Add the Major ID field to the Class table.
How to explain
By incorporating the Major ID field within the Class table, each Class record can reference a specific Major through its unique identifier.
This design allows multiple Class records (many) to be associated with a single Major record (one), enabling the establishment of a one-to-many relationship between Majors and Classes without duplicating Major information within the Class table.
The Complete Question
Major Id Major Name 10299313 10234952 Class ID Class Name 58995855 Astronomy 58993213 Fine Art An engineer is designing a database for college course information and wants to create a one-to-many relationship between Major records and Class records, since one Major can have many Classes associated with it. Which of the following would be a good way for the engineer to achieve this? a.) Add the Major Name field to the Class table. b.) Add the Major ID field to the Class table. c.) Add the Class Name field to the Major table. Physics Art d.) Add the Class ID to the Major table.