A transaction table tracks customer account activity. An administrator wants to ensure that every customer account number in the transaction table has a matching entry in the customer table.
Which capability makes this an appropriate use case for a relational model?
Referential integrity is a fundamental capability of the relational model that ensures the consistency and accuracy of data by enforcing constraints on the relationships between tables. In this case, referential integrity ensures that every customer account number in the transaction table has a corresponding entry in the customer table, thus maintaining the relational database's reliability.
A. Referential integrity. Referential integrity is a key capability of the relational model that ensures that the data in a relational database is consistent and accurate. It does this by enforcing constraints on the relationships between tables. In the case of the transaction table and the customer table