Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For each of the following, review the data in the images below and identify the (1) delimiter and (2) the qualifier (if applicable). Is an
- For each of the following, review the data in the images below and identify the (1) delimiter and (2) the qualifier (if applicable).
- Is an asset ID a good data field to use as a unique identifier in a data set needed to analyze depreciation? Why or why not?
- 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.
- 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.
- 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.
Images are not blurry. They have been reuploaded and are extremely clear. Thank you! :)
All information is present
File Edit Format View Help GLAccount Number, GLAccountName, Account Type, AccountClass, GLAccount StartingBalance, 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 File Edit Format View Help GLAccount Number GLAccountName Account Type AccountClass GLAccount StartingBalance 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 1 89890.87 888084.46 15100 Short-term Investments Assets Other ST Assets 398272.15 3 98272.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 16500 Equipment Assets "Plant, Property and Equipment" 2981919.07 2981919.07 16590 Accumulated Depreciation - Equipment Assets "Plant, Property and Equipment" -2367303.50 -2511726.38 -22288665.36 File Edit Format View Help GLAccount Number | GLAccount Name Account Type AccountClass GLAccountStartingBalance | GLAccountEndingBalance 11845 Operating Bank Account | Assets Cash| 4434537.984149727.38 11200 Petty Cash Assets Cash 5000 5000 12987|Food Service Conference Accounts Receivable Assets Accounts Receivable2372.56|1323.36 13100 | Prepaid Expenses Assets Prepaid Expenses 550 550 14250 Hotel Pantry Inventory Assets Inventory|4073.315843.25 14260 Food Service Inventory Assets Inventory |189890.87888084.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.5632139466.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.51-2511726.38 Sales CustNum CustName 1167 Goodway 1168 Bigmart 1814 ValueChoice 1836 Runner's Market 1841 Neighborhood Athletic Supply 1842 Northern Lites Type TransNum TransDate Amount InvNum InvDate ShipDate CustNum 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 1003 12-Mar-19 $ 15,737.60 MA302 15-Mar-19 12-Mar-19 1167 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 Sales Sales File Edit Format View Help GLAccount Number, GLAccountName, Account Type, AccountClass, GLAccount StartingBalance, 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 File Edit Format View Help GLAccount Number GLAccountName Account Type AccountClass GLAccount StartingBalance 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 1 89890.87 888084.46 15100 Short-term Investments Assets Other ST Assets 398272.15 3 98272.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 16500 Equipment Assets "Plant, Property and Equipment" 2981919.07 2981919.07 16590 Accumulated Depreciation - Equipment Assets "Plant, Property and Equipment" -2367303.50 -2511726.38 -22288665.36 File Edit Format View Help GLAccount Number | GLAccount Name Account Type AccountClass GLAccountStartingBalance | GLAccountEndingBalance 11845 Operating Bank Account | Assets Cash| 4434537.984149727.38 11200 Petty Cash Assets Cash 5000 5000 12987|Food Service Conference Accounts Receivable Assets Accounts Receivable2372.56|1323.36 13100 | Prepaid Expenses Assets Prepaid Expenses 550 550 14250 Hotel Pantry Inventory Assets Inventory|4073.315843.25 14260 Food Service Inventory Assets Inventory |189890.87888084.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.5632139466.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.51-2511726.38 Sales CustNum CustName 1167 Goodway 1168 Bigmart 1814 ValueChoice 1836 Runner's Market 1841 Neighborhood Athletic Supply 1842 Northern Lites Type TransNum TransDate Amount InvNum InvDate ShipDate CustNum 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 1003 12-Mar-19 $ 15,737.60 MA302 15-Mar-19 12-Mar-19 1167 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 Sales SalesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started