You have to create a table, STUDENTS, with the columns:

STUDENT_ID, STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID. The following constraints have to be enforced on this table:

Each student must be uniquely identifiable by the STUDENT_ID.

The STUDENT_ID columns should not be left blank.

The student should not be less than 15 years of age.

The student can only take a course that is specified in the COURSE

table in the database. Which three constraints must be explicitly enforced on the table? (Choose three)

Question

You have to create a table, STUDENTS, with the columns:

STUDENT_ID, STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID. The following constraints have to be enforced on this table:

table in the database. Which three constraints must be explicitly enforced on the table? (Choose three)

Accepted Answer

B. foreign key constraint on the COURSE_ID column C. check constraint on the DATE_OF_BIRTH column F. primary key constraint on the STUDENT_ID columns

Answer

A. check constraint on the COURSE_ID column

Answer

D. unique key constraint on the STUDENT_ID column

Answer

E. not null constraint on the DATE_OF_BIRTH column

You have to create a table, STUDENTS, with the columns: STUDENT_ID, STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID. The following constraints have to be enforced on this table: - Each student must be…