Database Diagram

Hi There,

My Product data is coming form 4 different tables all linked by the unique ProdID.
ProdMaster (Holding product general information)
ProdLog (Holding the logistics information)
ProdIMG (Binary Image of the product)
ProdThumb (Binary Image for the thumbnail of the product)

When I query my tables I join the tables by the ProdID according to the information I need to retrieve and if I don't need the image I just query the data tables not the one containing the image.

I am wondering if it is necessary to create a table diagram? What would be the use and benefit in doing so?
Would it be useful for data integrity when deleting a product?

Your guidance is appreciated.

Best regards.
pascalmartinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
The diagram is informational only. It does not impose, implement, enforce any data integrity.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ryan ChongCommented:
>>I am wondering if it is necessary to create a table diagram? What would be the use and benefit in doing so?

I guess... not only database diagram, but a full documentation is always needed so that when people look at the document, it can have basic knowledge and understanding on how your system/database works/ or being designed.

personally, I think database diagram is optional IF you have a clear data dictionary and explain about the data relationship/ dependencies.
0
David AndersTechnician Commented:
Although for Filemaker, the basics apply to any relational database.
Manual - WhitePaperForFMPNovices.pdf
http://www.foundationdbs.com/Downloads/WhitePaperForFMPNovices.pdf
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.