RETAIL BOOK SHOP FACT and AUTHOR dims
Page 1 of 1
RETAIL BOOK SHOP FACT and AUTHOR dims
Modelling a Book shop chain -
Dimensions -
1) Book ( Will have vendor details as attributes )
2) Time
3) Store
-------------------
A book can have mutliple authors and an author can write multiple books.
I don't think FACT should have author related keys but still..
there are 2 ways..
a) Author dim is snow flaked from Book dimension. Book and Author connected on natural keys with 1-n relationship.
b) Create bridge between FACT and AUTHOR dim.
Dimensions -
1) Book ( Will have vendor details as attributes )
2) Time
3) Store
-------------------
A book can have mutliple authors and an author can write multiple books.
I don't think FACT should have author related keys but still..
there are 2 ways..
a) Author dim is snow flaked from Book dimension. Book and Author connected on natural keys with 1-n relationship.
b) Create bridge between FACT and AUTHOR dim.
Vishy- Posts : 75
Join date : 2012-02-28
Location : India
![-](https://2img.net/i/empty.gif)
» Fact modeling for DVD Rental Shop
» Partitioning Strategy for Fact and Dims in Oracle/DB2/Sybase
» Retail Point of Sale Fact Table Question
» Which Book? (Kindle Book issues)
» 1:M relationship between Dims?
» Partitioning Strategy for Fact and Dims in Oracle/DB2/Sybase
» Retail Point of Sale Fact Table Question
» Which Book? (Kindle Book issues)
» 1:M relationship between Dims?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum