locked
How to make ideal ERD database design for this situation RRS feed

  • Question

  • 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

    Friday, May 12, 2017 10:35 PM

Answers

All replies