You have been asked by a client to normalize the driver dimension and to create

Question

You have been asked by a client to normalize the driver dimension and to create multiple fact tables for the receipts that a driver collects for each of the new aggregation levels.

Fill in the blanks with the field names used in the star schema to accomplish this task.

Facts:
A driver is assigned to one and only one office.
An office is in to only one region and may have many drivers.
A region is located in one and only one country and a country can have many regions.

Drag the correct answers in alphabetical order in to corresponding pockets.

Explanation / Answer

If you have any doubts, please give me comment...

Reciepts_Office

Customer_ID
Date
Office_ID
Receipt_Total
Receipt_Count

Receipts_Region

Customer_ID
Date
Receipt_Count
Region_ID
Receipt_Total

Receipts_Driver

Customer_ID
Date
Driver_ID
Receipt_Count
Receipt_Total

Receipts_Country

Country_ID
Customer_ID
Date
Receipt_Count
Receipt_Total

Country
Country_ID
Country_Name

Region
Country_ID
Region_ID
Region_Name

Driver
Driver_ID
Driver_Name
Office_ID

Office
Office_ID
Office_Name
Region_ID

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.