Question

2) Explain Referential Integrity with the help of an example.​

Answer 1

Answer:

Referential integrity requires that a foreign key must have a matching primary key or it must be null. ... Examples of referential integrity constraint in the Customer/Order database of the Company: Customer(CustID, CustName) Order(OrderID, CustID, OrderDate)

Answer 2

Answer:

Referential Integrity;

• The association between tables is referred to as referential integrity.

• A primary key is required for each table in a database and can appear in other tables as a result of its connection to the data in those other tables.

• A foreign key is what is used when a primary key from one table appears in another table.

• It indicates that a proper reference must be made from a row in one table to another table.

• Examples of referential integrity restrictions seen in the company's customer/order database include Order from Customer.

• Values in a foreign key column must either be present in the primary key that the foreign key references, or they must be null, according to the Referential Integrity constraint.

#SPJ2