Problem What relation between Batch table and Ship data Table and Order Data table
Details I need to make database design to pharmaceutical company make production to
Drugs and then make order to it to outside country or inside country .
I have database have 4 tables
Product Table ID PRIMARYKEY
Trade Name
Generic Name
Batch Table Batch No
Product Id FORIGNKEY
Ship data Table ShipNo
Container No
Pallet No
Carton No
Package No
Order Data Table OrderDate
Quantity
Unit Price
Total Price
I dont have special requirements i need only standard ERD for my case I work in SQL server 2012