|
|
|
Re: designing a db [message #183836 is a reply to message #183103] |
Mon, 24 July 2006 02:02 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
I take an output driven approach. I only put into a database data that the user wants to take out. From the reverse point of view, find out what they want OUT of the data base and make sure that it is put in, or is derived in someway. Don't normalize the data too much and DO consider the number of tables that have to be joined to do a 'standard' query.
David
|
|
|