Explain Referenitial Integrity with the help of an explain ( class 10 )
Answers
Answered by
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
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