1. Create a database named city with a document composed of the key-value pairs listed below in a collection named inspections.

Key	Value
Id	20032-2017-ACME
certificate_number	9998888
business_name	ACME Explosives
date	Todays date
result	Business Padlocked
sector	Explosive Retail Dealer 999
address	number -> 1721 street -> Boom Road city -> BRONX zip -> 10463

Be sure the address is inserted as a sub-document, and use the JavaScript function Date() for Todays date. Verify your database creation and insertion using the findOne() function in the Mongo shell. Provide a screenshot as evidence.

2. To complete this step, type in the following Linux commands to perform the import in the right directory:

../startMongod.sh #first step will always be to start mongo

cd datasets/ #change into the directory with the datasets

mongoimport --db city --collection inspections ./city_inspections.json #mongo import utility see web resource for more info

Using the mongoimport tool, load the database city with documents found in the city_inspections.json file into the inspections collection. Verify your load by issuing the following queries:

a. db.inspections.find({"id" : "10021-2015-ENFO"})

b. db.inspections.find({"result":"Out of Business"},{"business_name":1}).limit(10) Provide s creenshots of the results as evidence.

3. Answer the following questions using MongoDB queries:

a. What is the distinct list of inspection results in the current inspections collection? How many are in the list? Use JavaScript code to find the answer.

b. What is the difference in the date data type for the business named AUSTIN 2012 versus your business document insertion of Acme Explosives?

c. How many businesses have been padlocked? (See Value column above.)