Question
Identify three issues with this star schema for sales orders. Briefly discuss how you would address each. An illustration presents two types of tables, which
Identify three issues with this star schema for sales orders. Briefly discuss how you would address each. An illustration presents two types of tables, which are: two Dimension tables on the left, a Fact table in the middle, and two Dimension tables on the right. The key notes below read: Key, Column, Calculated column, Measure, and Foreign Key. The data from the customer table under the left dimension table are as follows: Key, Customer I D; Column: Email, First Name, Gender, Last Name, and S s n; Calculated column: Name; Measure: Number Of Customers. The data from the sales person table under the left dimension table are as follows: Key, Social Security Number; Column: Age, Name, Position, Date Of Hire; Calculated column: Date Of Birth; Measure: Number Of Sales People. The data from the sales order table under the fact table are as follows: Key, Sales Order Line I D; Foreign key: Date, Item, and Sales Person; Column: Discount, Quantity Sold, Sales Order, Sales Price, and Sales Order Line Amount; Calculated column: Sales Order Line Net Amount; Measure: Number Of Sales Orders, Total Discount, Total Sales Order Amount, and Total Sales Order Net Amount. The data from the product type table under the right dimension table are as follows: Key, Item I D; Column: Color, Cost, Description, and Product Category; Measure: Number Of Items. The data from the calendar table under the right dimension table are as follows: Key, Date; Calculated column: Week day, Month, and Year. One customer under the left dimension table participates in n number of sales order under the fact table. One sales person under the left dimension table participates in n number of sales order under the fact table. One product type under the right dimension table flows to n number of sales order under the fact table. One calendar under the right dimension table occurs to n number of sales order under the fact table.
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