Consider the database table "Persons" having persons_ID as the primary key:…
2017
Consider the database table "Persons" having persons_ID as the primary key:
Person ID | Name | Age |
1000 | Rajan | 40 |
— | Jatin | -45 |
1001 | Rajesh | 35 |
What are the constraints violated by the above table?
Answer: C. Entity and domain integrities — person_ID is a primary key → it cannot be NULL → Entity integrity violated Age = −45 → invalid (negative value) → Domain integrity violated No foreign key →…
- A.
Relationship integrity
- B.
Referential integrity only
- C.
Entity and domain integrities
- D.
Referential and domain integrities
Attempted by 2403 students.
Show answer & explanation
Correct answer: C
person_ID is a primary key → it cannot be NULL → Entity integrity violated
Age = −45 → invalid (negative value) → Domain integrity violated
No foreign key → Referential integrity not violated
A video solution is available for this question — log in and enroll to watch it.