Monthly Archives: January 2024

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.

 Research Apple Home Pod. How does it interact with smart home devices? Alexa is now connected to smart home devices such as thermostats and microwaves. Find examples of other appliances that are connected to Alexa and write a report. 

Write  500 words or more explaining why this “OAuth” is important for your peers to understand. Be focused and specific. You should do a deep dive into a topic.

You MUST make a statement saying exactly what your topic is. 

Use at least five sources. Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list.  Example: “words you copied” (citation) These quotes should be one full sentence not altered or paraphrased. Cite your sources.

Currently Unavailable to complete

Dates are:  

01/05/2021-

01/30/2021 

 1) Note the various aspects of knowledge management, continuous innovation, and competitive advantage and how they integrate with one another. ( 250 to 300 words)

2) What is the difference between the Internet and the World Wide Web? Create at least three statements that identify the differences between the two.

3)  Find the information security policy at your place of employment or study. Is it a good policy? Does it meet the standards outlined in the chapter?

4)How diligent are you in keeping your own information secure? Review the steps listed in the chapter and comment on your security status

Discuss the importance of regular expressions in data analytics. Also, discuss the differences between the types of regular expressions.

Choose two types of regular expressions… For example, [brackets] (Matches the enclosed characters in any order anywhere in a string) and * wildcards (Matches the preceding character 0 or more times) and discuss the differences between the two.

Please be sure to include two or three differences for each. Include how they help manipulate data.

Discussion Length (word count): At least 250 words (not including direct quotes).

References: At least two peer-reviewed, scholarly journal references.

In 250 words or more, describe your company’s mission-critical system(s). Please include the following information. Include references and citations when/if applicable:

1. What functionalities those systems are serving?
2. What made the company classify these systems as mission-critical?

Describe the plain view doctrine, and why  it has such a significant impact on digital forensics? What are three approaches to determining whether the doctrine applies to a specific case.

Use your own words and do not copy  the work of another student.

Please go through the attachment for assignment details.

 Discussion  (Chapter 13): Research  Apple Home Pod. How does it interact with smart home devices?  Alexa is  now connected to smart home devices such as thermostats and microwaves.  Find examples of other appliances that are connected to Alexa and write a  report.