Compose a 750 words essay on Ismg 2050. Needs to be plagiarism free!For instance, I selected all the fields from the three tables. Then, I went ahead and put down California under the criteria section

Compose a 750 words essay on Ismg 2050. Needs to be plagiarism free!

For instance, I selected all the fields from the three tables. Then, I went ahead and put down California under the criteria section.

As for the second query, I choose the VC data table as my preferred choice of data for my query. By following the same procedure as in query 1, I choose the query design from the create query menu.

Then I went ahead and choose the violent robbery field from the table. I also choose the city table where I put down the states of Ohio and California on the criteria section. This enabled the query to only look for data in these two states only. Finally, I selected the totals from a design query, which allowed me to select which option I would like to compute. This included the sum, standard deviation, maximum and minimum totals under the group by drop down menu.

For the third query, I used the city and property crime data tables. I selected the create query that set up a query design process. I then linked the two tables together and proceeded on selecting all the fields from the property crime table and the cities from the city data table. However, under the cities I put down the letters R and S for the criteria and or rows on the query. This then brought the desired results.

Finally, in the fourth query I incorporated all the tables provided to come up with the results. First, I selected the design query from create menu and selected all the tables. I then proceeded in selecting all the required fields. In choose the city, the state, the property crime and violent crime