7. Below are excerpts from two data tables: a
customer table on the left and a sales transaction
table on the right. Invoices are billed to customers
on a bimonthly basis.
CustNum CustName
Type TransNum TransDate Amount
InvNum InvDate ShipDate CustNum
1167 Goodway
Sales 1001 9-Mar-19 $16,157.44 MA027 15-Mar-19 9-Mar-19 1836
1168 Bigmart
Sales 1002 10-Mar-19 $ 9,144.00 MA253 15-Mar-19 10-Mar-19 1168
1814 ValueChoice
Sales 1003 12-Mar-19 $15,737.60 MA302 15-Mar-19 12-Mar-19 1167
1836 Runner's Market
Sales 1004 15-Mar-19 $ 6,008.00 MB527 31-Mar-19 15-Mar-19 1841
1841 Neighborhood Athletic Supply
Sales 1005 18-Mar-19 $ 7,241.60 MB633 31-Mar-19 18-Mar-19 1842
1842 Northern Lites
Sales 1006 19-Mar-19 $ 4,224.00 MB527 31-Mar-19 19-Mar-19 1841
Sales 1007 22-Mar-19 $ 2,003.00 MB750 31-Mar-19 22-Mar-19 1167
Answer the following questions.
a. Identify the join that would best show all
transactions with customer details and explain
how this join works and the unique identifier you
would use for the join.
b. Identify a join that would show all customer and
transaction details and explain how this identifier
works and the unique identifier you would use
for the join.