Friday 24 May 2013

What is a composite Key?

Tags


What is a composite Key?


A composite key is a primary key composed of multiple columns used to identify a record uniquely

In our database , we have two people with the same name Robert Phil but they live at different places.
alt
Hence we require both Full Name and Address to uniquely identify a record. This is a composite key.



EmoticonEmoticon