The referential integrity rule requires that $\_\_\_\_.$

Question $1$ options:

every null foreign key value must reference an existing primary key value

an attribute have a corresponding value in the related table

every non$-$null foreign key value reference an existing primary key value in the related table

you delete a row in a table if its primary key does not have a matching foreign key value in the related table