This is similar to the for example amazon customers details and customer contact address and delivery address.
I am going to collect customer details and also customer contact address (or billing address) and also delivery address.
So the assumption is that the each customer has got one contact address and zero or 1 or more delivery addresses.
So I was wondering how can I make this ERD since in some situations the customers contact address and delivery address are the same and in another situations the customers contact address and delivery address are different and we may have more than one delivery addresses.
I have been thinking my different solutions for this scenarios but all the time I end up with duplication or null values.
I should mention that the rest of entities are related to the delivery processes therefore I need to have the delivery address in order to use it for the delivery process. So if I have got three different tables for customer and contact address and delivery address, in the situation that the contact address and delivery address are the same I can choose to repeat the address in both tables which is the repeating of data or I can choose to enter the address into the contact address table and no values for delivery address table however this will cause problem with the rest of delivery process since they will have no values for the delivery address to continue the delivery process.
i was just wondering whether it is possible to create these three tables and draw the ERD for them without using view. i was wondering whether i can apply different apply different type of relationships such as subtype and supertype or recursive and etc to create a simple relationship which allows the mentioned senario.