AS91879 Practice  Assignment - Timmy's Taxes

Scenario:

Timmy, your teenaged friend, has got their first job earning $3,000 a year and paying $315 of tax in the 2017/2018 tax year. Investigate where the New Zealand government spends this tax.
A) Organise your data into an appropriate form. B) Query the database for where the tax goes, and C) Present your data in graphs.

1. Organise
   Create a flatfile database showing all components of actual Crown (Government) Expenses from 2014/2015 – 2017/18. Using the source: https://www.interest.co.nz/news/93792/budget-2018-summary-all-spending-plans
   Your database must also calculate:
   • Total expenditure for each year,
   • What Percentage of total expenditure each item is in 2017/18
   • How much money goes to each area if a person pays $315 of tax in the 2017/2018 year.
2. Queries:
   What are the biggest areas of Government Expenses? Sort in descending order by size of expense. (2017/2018) only.
   How much money is spent on Social Security and Welfare each year?
   Calculate How much is spent on Education, as a Percentage of total expenses?
   Calculate How much was spent on Defense (Military) between 2014 and 2018?
   
3. Present

• Graph the changes in the biggest five areas of expenses over time.
• Graph the changes in overall expenditure over time?
• Show a graph breaking down all areas of expenditure in 2017/18
• If a person earns around $3,000 a year, and pays $315 in tax Graph how this money is split between the different areas of expense.
• In a sentence describe the main places Timmy’s Taxes go to.