Question: Given the tables have been created without foreign keys added, which of the following ALTER TABLE statements would create a foreign key on the coordinator
Given the tables have been created without foreign keys added, which of the following ALTER TABLE statements would create a foreign key on the coordinatorid in the email table to reference the coordinatorid in the coordinator table?
ALTER TABLE coordinator
ADD CONSTRAINT fkemail
FOREIGN KEY coordinatorid
REFERENCES email coordinatorid;
ALTER TABLE email
ADD CONSTRAINT fkemail
FOREIGN KEY coordinatorid
REFERENCES coordinator coordinatorid;
ALTER TABLE email
ADD CONSTRAINT fkemail
FOREIGN KEY coordinator coordinatorid
REFERENCES coordinatorid;
ALTER TABLE email
ADD CONSTRAINT
FOREIGN KEY coordinatorid
REFERENCES coordinator coordinatorid;
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
