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?
Exam PL-300 All QuestionsBrowse all questions from this exam
Question 37
Correct Answer: D
The relationship between the Customer and Transaction tables should be a one-to-many relationship from Customer to Transaction. This is because each customer (represented by CustomerID) can have multiple transactions, but each transaction is associated with only one customer. Therefore, the primary key (CustomerID) in the Customer table will relate to multiple entries in the Transaction table, making it a one-to-many relationship.
Discussion
RickyAndOption: D
Correct
GPerez73
It is correct for me
SamuComqiOption: D
I passed the exam today (948/1000). My answer was: - one-to-many from Customer to Transaction
AyoJose
How many questions was it please?
IgetmyroleOption: D
D is the correct answer. Each customer can have multiple transactions (one-to-many relationship), as a customer can make multiple transactions over time.
hungry85Option: D
D is correct because a single customer can have many transactions and this transactions have their transactions id.
Cyprien_BOption: D
Correct
AZFabioOption: D
Please, MS, send questions like that in the exam... :-)
Kiran37
correct answer
GiudittaOption: D
this was on exam on 14/03/2024 i scored 948 my answer was D
RedRossOption: D
OBVIOUS!!
benni_aleOption: D
Per me è la cipolla
28485e1
This was on my exam, 2/2024.
edbf978Option: D
Correct
nick0651Option: D
D is the correct answer
inejoOption: D
D es la ideal
brunoquintelaOption: D
Correto
rb_pbOption: D
a customer is unique in the `Customer` table. However, a unique customer can possess multiple transactions in the `Transactions` table. Hence 1-MANY relationship is obvious answer. So, option D