Friday, 24 May 2013

What is a composite Key?


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.
Hence we require both Full Name and Address to uniquely identify a record. This is a composite key.