Which three constraints must be explicitly enforced on the table?

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)

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)

A.
check constraint on the COURSE_ID column

B.
foreign key constraint on the COURSE_ID column

C.
check constraint on the DATE_OF_BIRTH column

D.
unique key constraint on the STUDENT_ID column

E.
not null constraint on the DATE_OF_BIRTH column

F.
primary key constraint on the STUDENT_ID columns

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *