Which design should you use?

DRAG DROP

You need to extend the schema design to store the product dimension data.

Which design should you use? To answer, drag the appropriate table or tables to the correct location or locations in the answer area. (Fill from left to right. Answer choices may be used once, more than once, or not all.)

View Answer

Answer:

Explanation:

/ The schema design must be extended to include the product dimension data.

* DimProduct table need to contain a foreign key to the DimSubCategory table. No further SubCategory data should be stored in the DimProduct table.

* No time related columns (StartDate, EndDate) should be included in the DimProduct table.