| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
12-14-10, 12:58
|
|
Registered User
|
|
Join Date: Dec 2010
Posts: 4
|
|
|
Beginner's Database Warehousing Question
|
|
thanks for the help r937, got it solved by a friend.
|
Last edited by BrandonEZ; 12-15-10 at 04:34.
|
12-14-10, 14:49
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
|
|
Quote:
Originally Posted by BrandonEZ
should the ItemID and StoreID in my fact table
|
which fact table? could you show it please?
|
|
12-14-10, 18:06
|
|
Registered User
|
|
Join Date: Dec 2010
Posts: 4
|
|
|
|
thanks for the help r937, got it solved by a friend.
|
Last edited by BrandonEZ; 12-15-10 at 04:34.
|
12-14-10, 18:09
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
|
|
yeah, i know what a fact table is
you mentioned three tables, and then asked about linking your fact table to the sales table
so what does your fact table look like?
|
|
12-14-10, 18:17
|
|
Registered User
|
|
Join Date: Dec 2010
Posts: 4
|
|
thanks for the help r937, got it solved by a friend.
|
Last edited by BrandonEZ; 12-15-10 at 04:34.
|
12-14-10, 18:28
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
|
|
based solely on the information you've provided so far, i would say that the sales table ~is~ your fact table
i mean, what other data do you have? this is why i was asking to see your fact table -- what else do you intend to store?
|
|
12-14-10, 18:41
|
|
Registered User
|
|
Join Date: Dec 2010
Posts: 4
|
|
thanks for the help r937, got it solved by a friend.
|
Last edited by BrandonEZ; 12-15-10 at 04:34.
|
12-15-10, 11:21
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
|
|
So, you got your friend to do you homework for you?
Quote:
Originally Posted by BrandonEZ
Hi all.
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:
ITEM(ItemID, ItemName, Price, Description)
SALES(ItemID, StoreID, ItemDeliveredDate)
STORE(StoreID, StoreName, City, Address)
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.
blindman 
www.chess.com: "sqlblindman"
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
Beginner's Database Warehousing Question
