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.