How to make ideal ERD database design for this situation

Posted by Ahmedsa under Sql Server on 5/12/2017 | Points: 10 | Views : 197 | Status : [Member] | Replies : 2
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




Responses

Posted by: Jitendrasoft09 on: 5/13/2017 [Member] [MVP] Starter | Points: 25

Up
0
Down
There is no much complicated. If you understand the requirement then ERD can be designed easily. First of all understand the each part of your table and how the data is related to different tables. then accordingly design your ERD diagram. Hope it helps you. try it now.
https://www.visual-paradigm.com/tutorials/erd.jsp

Jitendra Kumar
If my post helps you, plz mark as an answer.

Ahmedsa, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ahmedsa on: 5/13/2017 [Member] Starter | Points: 25

Up
0
Down
I categorize datat to tables as above
but ship data table join to order data tables or ship data table

Ahmedsa, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response