STC Corporation's enterprise resource planning system contains a cash payments table, a cash receipts table and a cash table.Foreign keys in the cash payments table would include: (i) vendor ID, (ii) account number, (iii) cash payment date.

Question

Quizplus · Accepted Answer

Foreign keys are used to link tables together in a database. In the context of a cash payments table, the vendor ID and account number would serve as foreign keys linking the payments table to the vendors and accounts tables, respectively. The cash payment date would not be a foreign key but rather a regular attribute of the cash payments table, as it does not link to another table but simply records the date of the transaction.

STC Corporation's Enterprise Resource Planning System Contains a Cash Payments