Question: I need help with this assignment for my Advanced Database Class. Using MongoDB 1. Create a Database with the first part of your KSU email

I need help with this assignment for my Advanced Database Class.

Using MongoDB

1. Create a Database with the first part of your KSU email address. (For example, for jdow@students.kennesaw.edu, the database name jdow.)

2. Import zips.json into your Database, and collection zipcode. (provide commands you used and screenshot of the results)

3. Write and Run a Mongo Shell command which is equivalent to "SELECT * FROM zipcode WHERE pop>100000" (provide commands you used and screenshot of the results)

4. Write and Run a Mongo Shell command which is equivalent to "SELECT * FROM zipcode WHERE city=' OIL CITY'" (provide commands you used and screenshot of the results)

5. Write and Run a Mongo Shell command which is equivalent to "UPDATE zipcode SET state='Texas' WHERE state='TX'" (provide commands you used and screenshot of the results)

6. Write and Run a Mongo Shell command which is equivalent to "DELETE FROM zipcode WHERE city LIKE '%TREE%'" (provide commands you used and screenshot of the results)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!