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 coordinator_id in the email table to reference the coordinator_id in the coordinator table?
ALTER TABLE coordinator
ADD CONSTRAINT fk_email
FOREIGN KEY (coordinator_id)
REFERENCES email (coordinator_id);
ALTER TABLE email
ADD CONSTRAINT fk_email
FOREIGN KEY (coordinator_id)
REFERENCES coordinator (coordinator_id);
ALTER TABLE email
ADD CONSTRAINT fk_email
FOREIGN KEY coordinator (coordinator_id)
REFERENCES coordinator_id;
ALTER TABLE email
ADD CONSTRAINT
FOREIGN KEY (coordinator_id)
REFERENCES coordinator (coordinator_id);

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!