CODEWITHSUNDEEP
sql-server-2008foreign-key-relationship
user752709
user752709

Reputation: 85

Establish One-Many Relationship between tables

I have two tables and I need to establish a 1-many relation among them, as an example: 1 Customer can have many Order(s). What is a good way to create keys on the Order table such that there can be many rows in Orders, relating to one/same Customer details? i.e can I have cases when there are 2 rows with same CustomerID inserted into Order (1-many relation on CustomerID foreign key)

Assume Customer table has columns:

CustomerID (key)
Name 
OtherColumns

Order:

<IsaKeyNeeded>
customerID (foreign key) 
OrderName

Another question I have is does 'Order' need to have it's own key?

Upvotes: 0

Views: 791

Answers (1)

DCNYAM
DCNYAM

Reputation: 12126

You have it set up correctly ... the Order table should have a foreign key to the Customer table. This establishes the relationship of one customer to many orders. Just do not make the CustomerID a unique key.

To answer your other question ... yes, the Order table should have it's own primary key.

Upvotes: 1

Related Questions