ahmed salah

ahmed salah

  • NA
  • 530
  • 141k

How to make ideal ERD database design for this situation

May 12 2017 6:37 PM

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


Answers (1)