what is the difference between a primary key and a composite key?
Primary key is that column of the table whose every row data is uniquely identified. Every row in the table must have a primary key and no two rows can have the same primary key. ... Composite Key is a form of the candidate key where a set of columns will uniquely identify every row in the table.