Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In a STAR schema to track the shipments for a distribution company, the following dimension tables are found: ( 1 ) time, ( 2 )
In a STAR schema to track the shipments for a distribution company, the following
dimension tables are found: time, customer shipto shipfrom, product, type
of deal, and mode of shipment. Review these dimensions and list the possible attributes for
each of the dimension tables. Also, designate a primary key for each table. Draw out the STAR schema.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started