Click the Exhibit button. The tables shown in the exhibit have been created for a class enrollment system where a course can be assigned to many classes. The class table joins to the course table on the course_num columns. Which two of the following SQL statements are required to establish a referential integrity relationship between these tables? (Choose two.)

Question

Accepted Answer

C. ALTER TABLE course ADD CONSTRAINT (PRIMARY KEY (course_num)); D. ALTER TABLE class ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES course);

Answer

A. ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (class_id));

Answer

B. ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (course_num));

Answer

E. ALTER TABLE course ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES class);

Click the Exhibit button. The tables shown in the exhibit have been created for a class enrollment system where a course can be assigned to many classes. The class table joins to the course table on…

Question

Exhibit

Options

How the community answered

Community Discussion