Which relationship should you use to link the tables?

You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.

Which relationship should you use to link the tables?
A . one-to-many from Customer to Transaction
B . one-to-one between Customer and Transaction
C . one-to-many from Transaction to Customer
D . many-to-many between Customer and Transaction

View Answer

Answer: A

Explanation:

Each customer can have many transactions.

For each transaction there is exactly one customer.