Table Desing Enhancement Help

Hi all

I have the following scenario and I need some experts advice on the design as I am a new developer. I have attached the database please do check it. I am open to all suggestions so please comment if anyone thinks of a better design.





Each Customer has many Orders. Each Customer has many Contacts.

Each Customer has many DeliveryAddresses as we are only dealing with the Delivery Addresses.

Each DeliveryAddress has one Contact and Each Contact is linked with Many DeliveryAddresses.

Each Order has many Deliveries . Each Delivery has one Address and Each Address can have many Deliveries.

Each Delivery Has one Transport. One transport is used for many Deliveries.



A small description is that we are only dealing with customer DeliveryAddresses and each DelAddress has a contactPerson responsible for communication.



One key point would be as each customer has many deliveryAddresses we need to know exact DeliveryAddress for each order.

Now I have created the Design and need expert suggestions before I go ahead with as I have limited knowledge in relationship and design.



I am very thankful to you guys in advance



Thank you

Attached Files

DatabaseDesing.zip (63.2 KB)

Table Desing Enhancement Help