ERD or STAR SCHEMA [message #139514] |
Wed, 28 September 2005 07:39 |
singhsanjay
Messages: 2 Registered: September 2005 Location: london
|
Junior Member |
|
|
hello ,
i am designing a decision support system for the retail store, for that i need a database that will cantain all the information about the products ,sales etc.
as a usuall practice of designing a database is based on the ERD
i.e. we follows the ERD for creating the tables , but if u see the all the queries need to be answered are answered by the star schemma that means your tables would be different from the ones that were used in ERD . so
can anyone please help me out from this confussion which one should i follow for creating the datbase ERD or STAR SCHEMA.
regards
sanjay
|
|
|
|