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 1167 Goodway 1168 Bigmart 1814 ValueChoice 1836 Runner's Market 1841 Neighborhood Athletic Supply 1842 Northern Lites Type Trans Num TransDate Amount InvNum InvDate ShipDate CustNum Sales 1001 9-Mar-19 $ 16,157.44 MA027 15-Mar-19 9-Mar-19 1836 Sales 1002 10-Mar-19 $ 9,144.00 MA253 15-Mar-19 10-Mar-19 1168 Sales 1003 12-Mar-19 $ 15,737.60 MA302 15-Mar-19 12-Mar-19 1167 Sales 1004 15-Mar-19 $ 6,008.00 MB527 31-Mar-19 15-Mar-19 1841 Sales 1005 18-Mar-19 $ 7,241.60 MB633 31-Mar-19 18-Mar-19 1842 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. 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 1167 Goodway 1168 Bigmart 1814 ValueChoice 1836 Runner's Market 1841 Neighborhood Athletic Supply 1842 Northern Lites Type Trans Num TransDate Amount InvNum InvDate ShipDate CustNum Sales 1001 9-Mar-19 $ 16,157.44 MA027 15-Mar-19 9-Mar-19 1836 Sales 1002 10-Mar-19 $ 9,144.00 MA253 15-Mar-19 10-Mar-19 1168 Sales 1003 12-Mar-19 $ 15,737.60 MA302 15-Mar-19 12-Mar-19 1167 Sales 1004 15-Mar-19 $ 6,008.00 MB527 31-Mar-19 15-Mar-19 1841 Sales 1005 18-Mar-19 $ 7,241.60 MB633 31-Mar-19 18-Mar-19 1842 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