PrepAway - Latest Free Exam Questions & Answers

Category: 1D0-541

Exam 1D0-541: CIW Database Design Specialist

What are the referential constraints for the relations defined in these relation definitions?

Consider the following relation definitions:
STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 )
Primary Key Student_Number
HOUSING(
Housing_ID: integer NOT NULL
Student_Number: integer NOT NULL
Building: variable length character string length 25 ) Primary Key Housing_ID
Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO ACTION
ON UPDATE CASCADE
What are the referential constraints for the relations defined in these relation definitions?


Page 2 of 1912345...10...Last »