Avatar of tablaFreak
Flag for United States of America

asked on 

SQL Server database diagram


I'm trying to create an ER diagram in SQL server, and am not understanding how to tie multiple tables to a parent table, such as customer_address and customer_order to the customer table. If I associate the customer_id as a foreign key in address and order, I get a conflict error. So how do you associate multiple one-to-many relationships all referencing customer_id in the diagram?

Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Jim Horn

8/22/2022 - Mon