Category: 1D0-541

Exam 1D0-541: CIW Database Design Specialist

Which integrity constraint is violated in this relation definition?

Consider the following relation definition:

STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL) Primary Key Student_Number
HOUSING(
Housing_ID: integer NOT NULL
Student_Number: integer NOT NULL
Building: variable length character string length 25 NOT NULL) Primary Key Housing_ID
Foreign Key Student_Number References
STUDENT(Student_Number)
ON DELETE NO CHECK
ON UPDATE

Which integrity constraint is violated in this relation definition?


Page 1 of 1912345...10...Last »