Question: I need help identifying the facts, dimensions, attributes and keys and drawing a star schema for dimensional models thank you please do the diagram correctly
I need help identifying the facts, dimensions, attributes and keys and drawing a star schema for dimensional models thank you please do the diagram correctly because I do not understand star schema and mainly need database diagram

Design a data warehouse for an auto dealer: The data warehouse has to allow the dealer to analyze daily Sales at least with respect to the Cars, Customers, and Time. The company needs to analyze: o The car with respect to its model, year, make, features, mileages, body o The customers with respect to their spatial location, by considering at least cities, regions, states, zipcode. o The dealer records daily sales o The dealer is interested in learning at least the quantity, total sales, discounts if any and commissions (if any) Identify facts, dimension, attributes and any measures related to facts. Make sure you include your keys in the schema Draw a star schema
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
