Answered step by step
Verified Expert Solution
Link Copied!

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

  1. For each of the following, review the data in the images below and identify the (1) delimiter and (2) the qualifier (if applicable).
    1. File Edit Format View Help GLAccount Number, GLAccountName, Account Type, AccountClass, GLAccount StartingBalance, GLAccountE
    2. File Edit Format View Help GLAccount Number GLAccountName Account Type AccountClass GLAccount StartingBalance GLAccountEnding
    3. File Edit Format View Help GLAccount Number | GLAccount Name Account Type AccountClass GLAccountStartingBalance | GLAccountEn
  2. 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?
  3. 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.

Sales CustNum CustName 1167 Goodway 1168 Bigmart 1814 ValueChoice 1836 Runners Market 1841 Neighborhood Athletic Supply 1842

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.

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


File Edit Format View Help GLAccountNumber, GLAccountName, AccountType, AccountClass,GLAccountStartingBalance, GLAccountEndingBalance 11845,Operating Bank Account, Assets, Cash,4434537.98,4149727.38 11200, Petty Cash, Assets, Cash, 5000.00,500e.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, 18989e.87,888084.46 15100, Short-term Investments, Assets, Other ST Assets, 398272.15,398272.15 16100, Land and Improvements,Assets, "Plant, Property and Equipment", 296208e.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

Step by Step Solution

3.58 Rating (155 Votes )

There are 3 Steps involved in it

Step: 1

Image 1 The delimiter is a comma and the qualifier is double quotation marks Images2 The delimiter i... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Systems analysis and design

Authors: kenneth e. kendall, julie e. kendall

8th Edition

135094909, 013608916X, 9780135094907, 978-0136089162

More Books

Students also viewed these Mathematics questions

Question

When are closed questions appropriate for use in interviewing?

Answered: 1 week ago

Question

Calculate by hand, a linear trend forecast for periods 4-7.

Answered: 1 week ago