You need to recommend a solution that resolves the missing data issue. The solution must minimize the amount of development effort. What should you recommend?

Denormalizing the Products table would introduce more redundancy and increase the risk of data anomalies, which would worsen rather than resolve missing data issues.

Denormalizing the OrderDetails table would replicate data across multiple rows, increasing storage overhead and the potential for inconsistencies, not resolving missing data.

Normalizing the OrderDetails table does not address the root cause of the missing data, which originates in the Products table structure, making this an ineffective solution.

Normalizing the Products table eliminates data anomalies by organizing product data into a properly structured form, removing redundancy and ensuring referential integrity. This resolves missing data issues because normalized tables enforce consistent relationships, preventing orphaned or incomplete records. Normalization requires minimal development effort compared to application-level workarounds, as it is a structural database change.