The Reservations table is organized as follows: Reservations (ReservationID, ClassID, ClassInstructors, ClassPrice, OtherFees, CustomerID) Knowing about normalization,
Question:
The Reservations table is organized as follows:
Reservations (ReservationID, ClassID, ClassInstructors, ClassPrice, OtherFees, CustomerID)
Knowing about normalization, what superior way could you use to organize the data?
a. Create two tables: Reservations (ReservationID, ClassID, ClassInstructors, CustomerID); ClassPrice (ClassID, ClassPrice, OtherFees)
b. Create three tables: Reservations (ReservationID, ClassID, ClassInstructors, CustomerID); ClassPrice (ClassID, ClassPrice); ClassOtherFees (ClassID, OtherFees)
c. Add a new field to the table: Reservations (ReservationID, ClassID, ClassInstructors, PriceID, ClassPrice, OtherFees, CustomerID)
d. The data is organized in the best possible way.
Step by Step Answer:
Concepts Of Database Management
ISBN: 9780357422083
10th Edition
Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt