MS Access SQL Query Essay Paper

MS Access SQL Query Essay Paper

Write SQL queries based on the database in excel.

1. Create a Relationships between all the tables imported in part A as per your understanding.
2. Display Invoice item ids, Invoice names, and average invoice for each invoice item in descending order, If the item average is greater than $200.
3. Provide billing details (Invoice number, visitID, date, item name and id, amount) for those invoices which are not billed for ‘Lab work’, ‘Pharmacy’ and ‘Office visit’ and whose payment is not made. Also calculate the 7 % interest on the billed amount and display both interest amount as Late Penalty and the new billed amount.

Cyber Crimes and Data Analysis and Visualization Worksheet

Review the attached FBI 2019 & 2020 Annual Internet Crimes Reports and use the following link to create a data or graph table: https://www.tableau.com/academic/students

So, the main idea in this activity if for you to create an excel sheet first to include all the data elements about the computer or cyber crime you selected from 2019 and 2020 from the reports. You would try to identify as much information as you can on the one crime that you selected for both years and that includes identifying data elements “data sets” such as number of people impacted, amount of money to fix or address the crime, the amount of money damage caused by the crime, the number of people or cities or states etc impacted by the crime, the gender and background and so on. You would then import your excel sheet with the data selected from both years into Tableau and start questioning your data by selecting and dropping different fields as columns or rows for both years into the Tableau view and then changing them around looking at different visuals of your data as displayed by different types of graphs.

PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!