Advertisements
Advertisements
Question
State the following rules of DBMS.
Referential Integrity
Answer in Brief
Solution
- A referential integrity constraint is specified between two tables.
- In the Referential integrity constraints, if a foreign key in Table 1 refers to the Primary Key of Table 2, then every value of the Foreign Key in Table 1 must be null or be available in Table 2.
Example:
shaalaa.com
Is there an error in this question or solution?
APPEARS IN
RELATED QUESTIONS
State any one method of removing data from a cell in a spreadsheet.
What is the use of legends in a chart?
State the main advantages of an Action Query.
What symbol is used for the SELECT statement?
What is the difference between the Select and Project commands?
The ______ diagram gives a logical structure of the database graphically?
What is a relationship in databases? List its types.
What is meant by Database Partitioning?
What is the full form of DBMS?
The interface between the database and end users or application programs is referred to as ______.