Answer-first summary for fast verification
Answer: Dependent on ProductID only, Denormalize Company into Product table
The primary keys in the source data model suggest that the relationship between OrderItem and Product should be based on ProductID. Denormalization of the Company into the Product table eliminates the need for the CompanyID in the relationship, ensuring that analysis can be performed on order items by date, product, and customer without redundancy or the risk of incorrect relationships.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are presented with a source data model as shown in the exhibit. The primary keys in the tables are marked by a key symbol next to the respective columns. Your task is to create a dimensional data model that allows analysis of order items by date, product, and customer. What should you include in your solution? Select the appropriate options from the provided choices in the answer area.
A) Dependent on ProductID only B) Denormalize Company into Product table C) A new surrogate key which combines Product and Company D) Denormalize Company into Customer table
A
Dependent on ProductID only
B
Denormalize Company into Product table
C
A new surrogate key which combines Product and Company
D
Denormalize Company into Customer table