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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started