Results 1 to 8 of 8
  1. #1
    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 05:34.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by BrandonEZ View Post
    should the ItemID and StoreID in my fact table
    which fact table? could you show it please?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    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 05:34.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    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 05:34.

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    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 05:34.

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    So, you got your friend to do you homework for you?
    Quote Originally Posted by BrandonEZ View Post
    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"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •