CIW v5 Database Design Specialist 1D0-541 Question # 14 Topic 2 Discussion

CIW v5 Database Design Specialist 1D0-541 Question # 14 Topic 2 Discussion

1D0-541 Exam Topic 2 Question 14 Discussion:
Question #: 14
Topic #: 2

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?


A.

Entity integrity


B.

Domain constraint


C.

Referential integrity


D.

Enterprise constraint


Get Premium 1D0-541 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.