RETAIL BOOK SHOP FACT and AUTHOR dims

View previous topic View next topic Go down

RETAIL BOOK SHOP FACT and AUTHOR dims

Post  Vishy on 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

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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