Question: PLEASE DRAW A STAR SCHEMA DIAGRAM FOR ME. DO NOT WRITE A GIANT PARAGRAPH EXPLAINING IT, I JUST NEED HELP WITH THE DATABASE DIAGRAM PLEASE
PLEASE DRAW A STAR SCHEMA DIAGRAM FOR ME. DO NOT WRITE A GIANT PARAGRAPH EXPLAINING IT, I JUST NEED HELP WITH THE DATABASE DIAGRAM PLEASE AND THANK YOU!

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
