1. For each of the following, review the data in the images below and identify the (1) delimiter and (2) the qualifier (if applicable. If not, write N/A).

a

Delimiter:

Qualifier:

b.

Delimiter:

Qualifier:

c.

Delimiter:

Qualifier:

1. 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.

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.

Join type:

Explanation:

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.

Join type:

Explanation:

1. Which of the following three dates would likely require transformation to ensure format consistency? Explain your answer.

a. 07/13/2005 b. 98/03/17 c. 04-07-11

Answer:

Explanation:

GLAccountNumber, GLAccountName, AccountType, AccountClass, GLAccountStartingBalance, GLAccountEndingBalance 11845, Operating Bank Account, Assets, Cash,4434537.98,4149727.38 11200, Petty Cash, Assets, Cash, 5000.00,5000.00 12987, Food Service Conference Accounts Receivable, Assets, Accounts Receivable, 2372.56,1323.36 13100, Prepaid Expenses, Assets, Prepaid Expenses, 550.00,550.00 14250, Hotel Pantry Inventory, Assets, Inventory, 4073.31, 5843.25 14260, Food Service Inventory, Assets, Inventory, 189890.87, 888084.46 15100, Short-term Investments, Assets, Other ST Assets, 398272.15, 398272.15 16100, Land and Improvements, Assets, "Plant, Property and Equipment", 2962080.00,2962080.00 16200,Buildings \& Building Improvements,Assets, "Plant, Property and Equipment", 29298977.56,32139466.95 16290, Accumulated Depreciation - Building \& Improvements, Assets, "Plant, Property and Equipment", -21768847.25,-22288665.36 16500, Equipment, Assets, "Plant, Property and Equipment", 2981919.07, 2981919.07 16590, Accumulated Depreciation - Equipment, Assets, "Plant, Property and Equipment", 2367303.50,2511726.38 GLAccountNumber|GLAccountName|AccountType|AccountClass|GLAccountStartingBalance|GLAccountEndingBalance 11845|Operating Bank Account|Assets|Cash|4434537.98|4149727.38 11200|Petty Cash|Assets|Cash|5000|5000 12987|Food Service Conference Accounts Receivable |Assets|Accounts Receivable|2372.56|1323.36 13100|Prepaid Expenses|Assets|Prepaid Expenses|550|550 14250|Hotel Pantry Inventory|Assets|Inventory|4073.31|5843.25 14260|Food Service Inventory|Assets|Inventory|189890.87|888084.46 15100|Short-term Investments|Assets|Other ST Assets|398272.15|398272.15 16100|Land and Improvements|Assets|Plant, Property and Equipment|2962080|2962080 16200|Buildings \& Building Improvements|Assets|Plant, Property and Equipment|29298977.56|32139466.95 16290|Accumulated Depreciation - Building \& Improvements|Assets|Plant, Property and Equipment|-21768847.25|-22288665.36 16500|Equipment|Assets|Plant, Property and Equipment|2981919.07|2981919.07 16590|Accumulated Depreciation - Equipment|Assets|Plant, Property and Equipment|-2367303.5|-2511726.38 \begin{tabular}{|r|l|} \hline CustNum & CustName \\ \hline 1167 & Goodway \\ \hline 1168 & Bigmart \\ \hline 1814 & ValueChoice \\ \hline 1836 & Runner's Market \\ \hline 1841 & Neighborhood Athletic Supply \\ \hline 1842 & Northem Lites \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Type & TransNum & TransDate & Amount & InvNum & InvDate & ShipDate & CustNum \\ \hline Sales & 1001 & 9-Mar-19 & $16,157.44 & MA027 & 15-Mar-19 & 9-Mar-19 & 1836 \\ \hline Sales & 1002 & 10-Mar-19 & \$ 9,144.00 & Ma253 & 15-Mar-19 & 10-Mar-19 & 1168 \\ \hline Sales & 1003 & 12-Mar-19 & $15,737.60 & MA302 & 15-Mar-19 & 12-Mar-19 & 1167 \\ \hline Sales & 1004 & 15-Mar-19 & $6,008.00 & MB527 & 31-Mar-19 & 15-Mar-19 & 1841 \\ \hline Sales & 1005 & 18-Mar-19 & S 7,241.60 & MB 633 & 31-Mar-19 & 18-Mar-19 & 1842 \\ \hline Sales & 1006 & 19-Mar-19 & \$ 4,224.00 & MB527 & 31-Mar-19 & 19-Mar-19 & 1841 \\ \hline Sales & 1007 & 22-Mar-19 & S 2,00B.00 & MB750 & 31-Mar-19 & 22-Mar-19 & 1167 \\ \hline \end{tabular}