In a well-designed and normalized database,which of the following attributes would be a foreign key in a cash receipts table?
A) Customer number
B) Cash receipt date
C) Remittance advice number
D) Customer check number

Question

Quizplus · Accepted Answer

A customer number would be a foreign key in a cash receipts table as it would link the cash receipt to the customer who made the payment. A foreign key is a field in the table that links to a primary key in another table, establishing a relationship between the two tables. The other attributes listed (cash receipt date, remittance advice number, and customer check number) would not necessarily be foreign keys in a cash receipts table as they do not link to another table or establish a relationship between multiple tables.

In a Well-Designed and Normalized Database,which of the Following Attributes