Question: Add the appropriate foreign key ( s ) to the Treatment _ Appt table. Select the correct SQL . a . ALTER TABLE Treatment _

Add the appropriate foreign key(s) to the Treatment_Appt table. Select the correct SQL.
a. ALTER TABLE Treatment_Appt
ADD FOREIGN KEY (APPOINTMENT_ID) REFERENCES Appointments (APPOINTMENT_ID);
b. ALTER TABLE Treatment_Appt
ADD FOREIGN KEY (APPOINTMENT_ID) REFERENCES Appointments (APPOINTMENT_ID);
ALTER TABLE Treatment_Appt
ADD FOREIGN KEY (TREATMENT_ID) REFERENCES Treatment (TREATMENT_ID);
c. ALTER TABLE Treatment_Appt
ADD FOREIGN KEY (TREATMENT_ID) REFERENCES Treatment (TREATMENT_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!