Question: You have been asked to develop an analytical database to analyze local and federal sales tax compared to value - added tax. An excerpt of

You have been asked to develop an analytical database to analyze local and federal sales tax compared to value-added tax. An excerpt of your data table is presented.
\table[[SaleID,Date,SaleLocation,SaleAmount,LocalTax,SalesTax,VAT],[1001,525?2024,USA,$197,0.02,0.0685,],[1002,526?2024,USA,$113,0.02,0.0685,],[1003,527?2024,MEX,$155,,,0.16],[1004,528?2024,MEX,$423,,,0.16],[1005,529?2024,CAN,$88,,,0.05],[1006,530?2024,AUS,$250,,,0.1]]
You have started the process and are now ready to create the data dictionary. For each of the blank spaces designated with a number in the following table, identify the appropriate sentence or term to create the data dictionary. Each term or sentence will be used only once.
Name
1
Date
SaleLocation
4.
5.
SalesTax
7.
LocalTax
e-
SaleAmount
SaleID
Sa
The date the sale was made
The location where the sale was made
The percentage of federal sales taxes collected at the time of the sale VAT
Description
Unique identifier for each sale made.
2.
3.
The total amount of the sale before taxes.
The percentage of local taxes collected at the time of the si
6.
The value-added-tax percentage to be collected related to
You have been asked to develop an analytical

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!