A database contains a table named PETS and a table named OWNERS.

The OWNERS table contains information about pet owners, and the

PETS table stores details about various pets. These tables are related

through a common attribute, such as an owner ID$.$

Suppose we delete the row with owner ID $=5$ because this owner no longer owns any Pets. How is referential integrity assured?

Question $11$ options:

The database system must ensure that all rows with foreign keys are removed from the PETS table.

The database system must ensure that there are no pets in the PETS table with owner id $=5.$

All owners with owner ID $=5$ must be deleted from the OWNERS table.

All Pets in the PETS table must be re indexed to assure that there are no duplicates.