Computer Science, asked by jain79148, 11 hours ago

Explain Referenitial Integrity with the help of an explain ( class 10 ) ​

Answers

Answered by pcp240306gmailcom
0

Answer:

A value appearing in a one table for a given set of attributes also appears for another set of attributes in another table. This is called referential integrity. • A referential integrity constraint is specified between two tables and is used to maintain the consistency among tuples in the two relations.

Explanation:

please mark me as brainlist and please fol।ow mee

Answered by MysticalStar07
10
  • A value appearing in a one table for a given set of attributes also appears for another set of attributes in another table. This is called referential integrity.

  • A referential integrity constraint is specified between two tables and is used to maintain the consistency among tuples in the two relations.

  • The tuple in one table refers only to an existing table in another relation.

Referential integrity in SQL:-

  • Foreign key is used to show relation into two tables in relational algebra.

  • This helps in maintaining consistency in database, as foreign key cannot be inserted, deleted or updated.
Similar questions