Create a primary key constraint on the owner column in the owners table and make the owner_name
Fantastic news! We've Found the answer you've been seeking!
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 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.
Related Book For
Accounting Information Systems
ISBN: 9780132871938
11th Edition
Authors: George H. Bodnar, William S. Hopwood
Posted Date: