Hi All,
I have to create a database in which a customer can provide multiple shipping addresses,how to assign a customer entity to multiple adddresse??
a.Can I take CustmerID as a FK in Address and join them.
b.If both table have M:N relationship I can take a 3rd table and give PK of both the table ie composite keys I can take.

Thanks

a. yes

b. yes

Here is a Data Model on my Database Answers Web Site that shows what a Customer with multiple Addresses looks like :-
Customer Addresses Data Model

HTH

Barry Williams
London,England