Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Used MongoDB. Write a script command that will list the Rentals. ( db.getCollection('nameOfDatabase').find({}) ) Include all rental information. Update the Rentals to show a return

Used MongoDB. Write a script command that will list the Rentals. ( db.getCollection('nameOfDatabase').find({}) ) Include all rental information.

Update the Rentals to show a return valid date on each rental.

Write a script that will only show each users' names and the movie titles they have rented.

/* 1 */ { "_id" : 1000, "firstName" : "John", "lastName" : "Turner", "phoneNumber" : [ "8085551212", "8015550055" ], "userType" : "A", "customerType" : "P", "banStatus" : "N", "Questions" : [ { "Question" : "What was the name of the first school that you attended", "Answer" : "Ponderosa Elementary" }, { "Question" : "What was the name of your favorite pet", "Answer" : "Domino" }, { "Question" : "What was your mother's maiden name", "Answer" : "Stokes" } ], "MovieID" : "TrGrt", "Title" : "True Grit", "copyNumber" : "1", "movieType" : "B", "rentalDate" : ISODate("2017-03-02T07:00:00.000Z"), "Actors" : [ { "ActorFirstName" : "John", "ActorLastName" : "Wayne" }, { "ActorFirstName" : "Glen", "ActorLastName" : "Campbell" } ], "Director" : [ { "DirectorFirstName" : "Henry", "DirectorLastName" : "Hathaway" } ], "Keywords" : "Western, Academy Award, Horses, Rooster Cogburn", "genre" : "Western", "genreDescription" : "A genre of various arts which tell stories set primarily in the later half of the 19th century in the American Old West, often centering on the life of a nomadic cowboy or gunfighter armed with a revolver and a rifle who rides a horse. Cowboys and gunslingers typically wear Stetson hats, bandannas, spurs, cowboy boots and buckskins. Other characters include Native Americans, bandits, lawmen, bounty hunters, outlaws, soldiers (especially mounted cavalry), settlers and townsfolk." }

/* 2 */ { "_id" : 1001, "firstName" : "John", "lastName" : "Turner", "phoneNumber" : [ "8085551212", "8015550055" ], "userType" : "A", "customerType" : "P", "banStatus" : "N", "Questions" : [ { "Question" : "What was the name of the first school that you attended", "Answer" : "Ponderosa Elementary" }, { "Question" : "What was the name of your favorite pet", "Answer" : "Domino" }, { "Question" : "What was your mother's maiden name", "Answer" : "Stokes" } ], "MovieID" : "TrGrt", "Title" : "True Grit", "copyNumber" : "2", "movieType" : "D", "rentalDate" : ISODate("2017-04-05T07:00:00.000Z"), "Actors" : [ { "ActorFirstName" : "John", "ActorLastName" : "Wayne" }, { "ActorFirstName" : "Glen", "ActorLastName" : "Campbell" } ], "Director" : [ { "DirectorFirstName" : "Henry", "DirectorLastName" : "Hathaway" } ], "Keywords" : "Western, Academy Award, Horses, Rooster Cogburn", "genre" : "Western", "genreDescription" : "A genre of various arts which tell stories set primarily in the later half of the 19th century in the American Old West, often centering on the life of a nomadic cowboy or gunfighter armed with a revolver and a rifle who rides a horse. Cowboys and gunslingers typically wear Stetson hats, bandannas, spurs, cowboy boots and buckskins. Other characters include Native Americans, bandits, lawmen, bounty hunters, outlaws, soldiers (especially mounted cavalry), settlers and townsfolk." }

/* 3 */ { "_id" : 1002, "firstName" : "John", "lastName" : "Turner", "phoneNumber" : [ "8085551212", "8015550055" ], "userType" : "A", "customerType" : "P", "banStatus" : "N", "Questions" : [ { "Question" : "What was the name of the first school that you attended", "Answer" : "Ponderosa Elementary" }, { "Question" : "What was the name of your favorite pet", "Answer" : "Domino" }, { "Question" : "What was your mother's maiden name", "Answer" : "Stokes" } ], "MovieID" : "StrWrs", "Title" : "Star Wars", "copyNumber" : "1", "movieType" : "D", "rentalDate" : ISODate("2017-03-10T07:00:00.000Z"), "Actors" : [ { "ActorFirstName" : "Harrison", "ActorLastName" : "Ford" }, { "ActorFirstName" : "Cari", "ActorLastName" : "Fisher" } ], "Director" : [ { "DirectorFirstName" : "George", "DirectorLastName" : "Lucas" } ], "Keywords" : "Space, Adventure, Jedi", "genre" : "Action", "genreDescription" : "Action fiction is the literary genre that includes spy novels, adventure stories, tales of terror and intrigue cloak and dagger , and mysteries. This kind of story utilizes suspense, the tension that is built up when the reader wishes to know how the conflict between the protagonist and antagonist is going to be resolved or what the solution to the puzzle of a thriller is." }

/* 4 */ { "_id" : 1003, "firstName" : "Drew", "lastName" : "Weidman", "phoneNumber" : [ "8016267025", "8016266000" ], "userType" : "S", "customerType" : "P", "banStatus" : "N", "Questions" : [ { "Question" : "What was the name of the first school that you attended", "Answer" : "North Park" }, { "Question" : "What was the name of your favorite pet", "Answer" : "Bear" }, { "Question" : "What was your mother's maiden name", "Answer" : "Wise" } ], "MovieID" : "ShwRdmptn", "Title" : "Shawshank Redemption", "copyNumber" : "2", "movieType" : "D", "rentalDate" : ISODate("2017-04-28T07:00:00.000Z"), "Actors" : [ { "ActorFirstName" : "Time", "ActorLastName" : "Robbins" }, { "ActorFirstName" : "Morgan", "ActorLastName" : "Freeman" } ], "Director" : [ { "DirectorFirstName" : "Frank", "DirectorLastName" : "Darabont" } ], "Keywords" : "prison, escape, corruption", "genre" : "Drama", "genreDescription" : "These terms tend to indicate a particular setting or subject-matter, or else they qualify the otherwise serious tone of a drama with elements that encourage a broader range of moods." }

/* 5 */ { "_id" : 1004, "firstName" : "Drew", "lastName" : "Weidman", "phoneNumber" : [ "8016267025", "8016266000" ], "userType" : "S", "customerType" : "P", "banStatus" : "N", "Questions" : [ { "Question" : "What was the name of the first school that you attended", "Answer" : "North Park" }, { "Question" : "What was the name of your favorite pet", "Answer" : "Bear" }, { "Question" : "What was your mother's maiden name", "Answer" : "Wise" } ], "MovieID" : "GrdnsGlxy", "Title" : "Guardians of the Galaxy", "copyNumber" : "1", "movieType" : "B", "rentalDate" : ISODate("2017-05-10T07:00:00.000Z"), "Actors" : [ { "ActorFirstName" : "Chris", "ActorLastName" : "Pratt" }, { "ActorFirstName" : "Bradley", "ActorLastName" : "Cooper" } ], "Director" : [ { "DirectorFirstName" : "James", "DirectorLastName" : "Gunn" } ], "Keywords" : "bounty hunter, outer space, tree", "genre" : "Action", "genreDescription" : "Action fiction is the literary genre that includes spy novels, adventure stories, tales of terror and intrigue cloak and dagger, and mysteries. This kind of story utilizes suspense, the tension that is built up when the reader wishes to know how the conflict between the protagonist and antagonist is going to be resolved or what the solution to the puzzle of a thriller is." }

/* 6 */ { "_id" : 1005, "firstName" : "Drew", "lastName" : "Weidman", "phoneNumber" : [ "8016267025", "8016266000" ], "userType" : "S", "customerType" : "P", "banStatus" : "N", "Questions" : [ { "Question" : "What was the name of the first school that you attended", "Answer" : "North Park" }, { "Question" : "What was the name of your favorite pet", "Answer" : "Bear" }, { "Question" : "What was your mother's maiden name", "Answer" : "Wise" } ], "MovieID" : "ShwRdmptn", "Title" : "Shawshank Redemption", "copyNumber" : "2", "movieType" : "D", "rentalDate" : ISODate("2017-06-14T07:00:00.000Z"), "Actors" : [ { "ActorFirstName" : "Time", "ActorLastName" : "Robbins" }, { "ActorFirstName" : "Morgan", "ActorLastName" : "Freeman" } ], "Director" : [ { "DirectorFirstName" : "Frank", "DirectorLastName" : "Darabont" } ], "Keywords" : "prison, escape, corruption", "genre" : "Drama", "genreDescription" : "These terms tend to indicate a particular setting or subject-matter, or else they qualify the otherwise serious tone of a drama with elements that encourage a broader range of moods." }

/* 7 */ { "_id" : 1006, "firstName" : "Joe", "lastName" : "Smith", "phoneNumber" : [ "8011352353", "8016753623" ], "userType" : "S", "customerType" : "S", "banStatus" : "N", "Questions" : [ { "Question" : "What was the name of the first school that you attended", "Answer" : "McKiinley" }, { "Question" : "What was the name of your favorite pet", "Answer" : "Max" }, { "Question" : "What was your mother's maiden name", "Answer" : "Smith" } ], "MovieID" : "BlzngSddls", "Title" : "Blazing Saddles", "copyNumber" : "3", "movieType" : "B", "rentalDate" : ISODate("2017-10-15T07:00:00.000Z"), "Actors" : [ { "ActorFirstName" : "Gene", "ActorLastName" : "Wilder" }, { "ActorFirstName" : "Cleavon", "ActorLastName" : "Little" } ], "Director" : [ { "DirectorFirstName" : "Mel", "DirectorLastName" : "Brooks" } ], "Keywords" : "Western, Comedy, corrupt politician, Sheriff", "genre" : "Comedy", "genreDescription" : "Main emphasis is humour, designed to make the audience laugh through amusement by exaggerating characteristics or situations" }

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

PostgreSQL Up And Running A Practical Guide To The Advanced Open Source Database

Authors: Regina Obe, Leo Hsu

3rd Edition

1491963417, 978-1491963418

More Books

Students also viewed these Databases questions

Question

What is a current asset? What is a current liability?

Answered: 1 week ago

Question

What is American Polity and Governance ?

Answered: 1 week ago

Question

What is the difference between Needs and GAP Analyses?

Answered: 1 week ago

Question

What are ERP suites? Are HCMSs part of ERPs?

Answered: 1 week ago