recategorized by
2,043 views

2 Answers

1 votes
1 votes

 Referential integrity is a database concept that ensures that relationships between tables remain consistent. When one table has a foreign key to another table, the concept of referential integrity states that you may not add a record to the table that contains the foreign key unless there is a corresponding record in the linked table. It also includes the techniques known as cascading update and cascading delete, which ensure that changes made to the linked table are reflected in the primary table.

Hence,Option(B)Foreign key .
 

0 votes
0 votes
Ans B)Referential Integrity ---> Foreign key (one or more keys of one tables are derived from some other tables primary or unique key)

                                                                                                                                                                          so that it can    not have any invalid(non-existent) value. It can have either matched value of some primary or unique key of derived table or NULL

           Entity Integrity ---->Primary key (It can have only unique and NOT NULL  values i.e duplicates and NULL (unknown )  are not allowed
Answer:

Related questions

3 votes
3 votes
2 answers
1
go_editor asked Jul 13, 2016
3,627 views
The third normal form is based on the concept of_____Closure DependencyTransitive DependencyNormal DependencyFunctional Dependency
2 votes
2 votes
1 answer
3