database design advice

[mit99mh]

I've been asked to create a database where a stipluation is that a table entry can have 0,1,2,3 documents associated with it - these documents are unique to each entry - I modelled it but I wondered what designs others have used / would use in this instance.

Any advice much appreciated

 

[ptheriault]

mit,
Before anyone here can help you with your question you are going to have to provide a lot more information than you have here. I suggest you read this FAQ.

faq183-874

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[gmmastros]

I would encourage you to go a google search on [google]database normalization rules[/google]. Read the first couple articles it suggests. Most developers strive for 3rd order normalization.

I once read, "Normalize until it hurts, de-normalize until it works".

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom