Computer Science, asked by AnkitRay9227, 1 year ago

Where will we find the referential integrity command ?

(a) Tools
(b) View
(b) Format
(d) Table
(e) None of these

Answers

Answered by Anonymous
1
Hye!!!..
..
.
Answer is :-

✔ d). Table


Hope it helps ☺

#cheekU;-)
Answered by amithadavid
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