Question

if the price is displayed on the product table, why after 3nf does the unitprice exist on the orderline table? a.) for future planning purposes b.) the unitprice captures the price at the time of the order. c.) to help avoid connection errors d.) to add redundancy

Answer 1

After 3NF, the unit price exists on the orderline table to capture the specific price at the time of the order, ensuring accuracy and historical record-keeping for efficient queries. (option B)

In a normalized database design following the Third Normal Form (3NF), the inclusion of the unit price in the orderline table is typically done to capture the specific price associated with an item at the time of the order.

This helps in maintaining historical data and avoids issues related to changes in product prices over time. It is a way of denormalizing certain data to improve query efficiency and maintain the accuracy of order information in the context of the prices that existed when the order was placed.

The correct answer is b.) the unit price captures the price at the time of the order.