Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

RETAIL BOOK SHOP FACT and AUTHOR dims

Go down

RETAIL BOOK SHOP FACT and AUTHOR dims Empty RETAIL BOOK SHOP FACT and AUTHOR dims

Post  Vishy Fri Mar 02, 2012 1:32 am

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.

Vishy

Posts : 75
Join date : 2012-02-28
Location : India

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum