6K:105 Information Systems Project MSCI:30051Information Systems Project - Part BFor this part, it is assumed that your Iowa population database has been well designed and created fromPart A. Now you are asked to use the database to perform some Iowa population data analysis. Wehighly recommend that you use the starting file that we provide, made available on April 25th.There are a total of 6 questions worth 75 points (see specific question for assigned points), of which thefinal question is done using the Tableau software. There are 3 pages of instructions. Do not miss any!Save your Access file for part B as ”project-partB.accdb”.NOTE: 1) You need to name your queries in the format: QN-R: T, where N is the question number, R isthe query index number for a specific question, and T is a meaningful/descriptive name for that query.For example, if you need to write 3 queries to do the data-consistency check in Question 1, then the firstquery can be named as: Q1-1: County Population from PopulationDetail; 2) Remember that ID only is notsufficient – you need to show the corresponding CountyName/Gender/Race, etc.1. (15 points) [Data-consistency check] It is noted that: you may find out the total 2010 populationof each county from either the PopulationDetail table (originally from2010PopulationByGenderAgeRang.xlsx) or the RaceDetail table (originally from2010PopulationByRace.xlsx). The question is: is the population data consistent? Write one ormore queries to do the 2010 county-population consistency check.A partial portion of the final-query results looks like this –2. (10 points) Create two reports in Access: one is to display the top 10 counties with the mostpopulation, and the other to list the 10 counties with the least population.A partial portion of the first report looks like this –6K:105 Information Systems Project MSCI:300523. (10 points) We are interested in not only the total AreaLand, AreaWater, and HouseUnit for eachcounty (in County table), but also the corresponding per capita data. Write one or more queriesto find out the per capita AreaLand/AreaWater/HouseUnit of each county.A partial portion of the query results looks like this –4. (10 points) Create a form to show the county’s basic info (Name, AreaLand, AreaWater,HouseUnit) along with its population by gender (1st subform) and by race (2nd subform), likethis. (Hint: You first need to create two queries for each subform. Then, create a form for theCounty table. After that, in County-form design view, drag and drop queries Q4-1 and Q4-2 fromthe navigation pane.) –6K:105 Information Systems Project MSCI:300535. (15 points) Write one or more queries to find out Iowa State's population percentage changefrom 1990 to 2010 for females.The column headings of the final-query results may look like this –6. (15 points) Create a Tableau visualization for the query in question 5 where you show thepercentage change in female population for each county from year 1990 to 2010 (percentagechange is computed using data for year 1990 and data for 2010 only. No intermediate years areincluded). Use the Tableau dashboard to export an image of your visualization as a file (.png) andupload it to the dropbox on ICON along with your completed Access file for part B.Good luck!
This question was answered on: May 23, 2022
This attachment is locked
Our expert Writers have done this assignment before, you can reorder for a fresh, original and plagiarism-free copy and it will be redone much faster (Deadline assured. Flexible pricing. TurnItIn Report provided)
May 23, 2022EXPERT
We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.
You can also use these solutions: