Question: Add a foreign key to Pet referencing Owner. Also, add a check constraint ensuring PET _ AGE is greater than 0 . Select the correct
Add a foreign key to Pet referencing Owner. Also, add a check constraint ensuring PETAGE is greater than Select the correct SQL
a ALTER TABLE Pet
ADD FOREIGN KEY OWNERID REFERENCES Owner OWNERID
ADD CHECK PETAGE ;
b MODIFY TABLE Pet
ADD FOREIGN KEY OWNERID REFERENCES Owner OWNERID
ADD CHECK PETID ;
c ALTER TABLE Pet
ADD FOREIGN KEY OWNERID ADD CHECK PETID ;
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
