Where will we find the referential integrity command ?
(a) Tools
(b) View
(b) Format
(d) Table
(e) None of these
Answers
Answered by
1
Hye!!!..
..
.
Answer is :-
✔ d). Table
Hope it helps ☺
#cheekU;-)
..
.
Answer is :-
✔ d). Table
Hope it helps ☺
#cheekU;-)
Answered by
0
We will find the referential integrity command in (a) Tools
- Referential integrity is a kind of integrity constraint for which a foreign key must have a matching primary key or it must be null
- This constraint is specified between two tables - parent and child - and it maintains compatibility between the rows in these tables
- An example of referential integrity constraints in the Student/Subject database of a School:
Student(StudentID, StudentName)
Subject(SubjectID, StudentID, SubjectMark) - The main objective of the referential integrity constraint is to ensure that there aren't any orphan records. "An orphan record is one whose foreign key FK value is not found in the corresponding entity – the entity where the PK is located"
- Referential integrity can be made sure by checking the Enforce Referential Integrity checkbox, which is found in the Edit Relationship popup box, under the Relationship group in Tools Tab.
Therefore, we will find the referential integrity command in (a) Tools
Similar questions
Music,
7 months ago
Math,
7 months ago
Computer Science,
1 year ago
Computer Science,
1 year ago
Math,
1 year ago
Math,
1 year ago