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
Get step-by-step solutions from verified subject matter experts
