So, you got your friend to do you homework for you?
Originally Posted by BrandonEZ
I have a simple question regarding warehousing but the conditions stated in the question is one that I have not encountered before:
A company operates a store with delivery stores. The company is setting up store data warehouse to store information for sales analysis. The total sales(total items sold and total dollars received) per day and per month for each item for each delivery store should be kept in the data warehouse.Data for the data warehouse are extracted from a company database. There are three tables:
Note: Primary keys are underlined.
Now design and draw the schema for the data warehouse to accurately represent the data warehouse for the store company. Choose suitable primary keys and foreign keys for the fact and dimension tables in the star schema.
The conditions are very straightforward, but my question is, should the ItemID and StoreID in my fact table be related to those of SALES which then relate to ITEM and STORE, or otherwise?
In the examples given in the lecture notes and the tutorials, only examples in which dimension tables are independent of each other were given so I am quite confused at this question.
...and then decided to delete the posts so that your professor won't find it?
If it's not practically useful, then it's practically useless.