Explain the difference between a primary key and a foreign key.
What will be an ideal response?
The primary key may consist of one or more fields whose values are used to uniquely identify each record in a table.
If the same field used as the primary key in one table is also used as a field in another table, and that field is used to create a relationship between the two tables, that field is called a foreign key in the second table. The foreign key is not used to uniquely identify records in the second table.
You might also like to view...
A heap is a complete binary tree. What is required for the tree to be complete?
What will be an ideal response?
What does the /etc/fstab file do?
What will be an ideal response?
________ helps you free up space on your storage devices
Fill in the blank(s) with correct word
What restrictions are necessary to ensure that a view is updatable?
What will be an ideal response?