DATABASE DESIGN PROBLEMS. READ AND ANSWER ALL PLEASE. THANKS.

=========

Which of the following code will create a foreign key named fk honnors on the column honors_subject of table students? The constraint is that the values need to reference the values of table HonnorsSubjects, column honors_subject_id. A It's not possible to create a foreign key after you have created a table. B ALTER TABLE Students ADD CONSTRAINT k_honnors FOREIGN KEY (honors_subject) REFERENCES HonnorsSubjects (honors_subject_id); C ALTER TABLE ADD CONSTRAINT Students.fk honnors (honors_subject) FOREIGN KEY REFERENCES HonnorsSubjects (honors_subject); D ALTER TABLE FOREIGN KEY REFERENCES Students (honors_ subject) E None of the above HonnorsSubjects ADD CONSTRAINT ik_honnors (honors_subject_id)