Hi all, I am currently designing a database for a warehouse but I cannot get the ERD Wright. The entities which I am using are( Warehouse, order,customer, suppliers, products) these are my tables but after handing in my assignment, it has been returned to me and been tolled there is a table missing. The only thing which I could think of will be (Delivery) table but I am not sure. Any help will be deeply appreciated.
my Current ERD relationships as fallows:
Warehouse-> could have many -> orders
Warehouse -> could have many-> Suppliers
Suppliers -> could supply many-> Products
Orders -> could have many -> Product
Customer -> could have many -> Orders
I came up with these. hope someone could help me to get the ERD Wright for this assignment.