Answer 1.
A primary key is a column, or set of columns which uniquely identify a record. For example; Department table's primary key is the Dept number.
A foreign key is a column or set of columns in a table which have a corresponding relationship and a dependency on another table, specifically the dependency is on the primary key of a table.
|
Answer 2.
A primary key is a column, or set of columns which uniquely identify a record. For example; Department table's primary key is the Dept number.
|