I need to design a database that will track the supplies ordered from a
supplier as well as track these supplies when they a shipped to investigator
sites. I would have a Suppliers table, Product Table, Investigator Sites
Table, I get stuck on whether I should have a tables named Supplier Orders
Table and Supplier Order Details Table as well as Site Order Table and Site
Order Details.

I would really appreciate any help as I'm fairly new to designing databases.

Thank in advance for any help.

Regards,

Dee