Question: Create a primary key constraint on the owner column in the owners table and make the owner_name column the primary key. This must be done
- Create a primary key constraint on the owner column in the owners table and make the owner_name column the primary key. This must be done before a foreign key constraint can be created on the dogs table.
- Create a foreign key constraint on the dogs table. The dogs table will reference the owners table through the owner_name column (a foreign key/exported key for the owner_name column in the dogs table.)
- Test your foreign key constraint by adding a row to the owners table and then add a row to the dogs table with the same owner_name value.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
