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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Question Posted: