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.