Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

ICT704 Non Relational Database Systems

tag 0 Download 5 Pages / 1,124 Words tag 02-08-2021

Question:

Create a MongoDB database using the data provided to you in the ComicData_Assignment.xls spreadsheet. (There should only be one collection comics with each comic as a single document).
Insert data from the provided .xlsx file into MongoDB using the insert command
Create indexes which you think will be needed and beneficial
Create the following queries:

o List all of the comics in the collection
o Find the records that are published by Panini UK
o List just the publishers name for every comic
o List the distinct names of every publisher
o Count the number of comics in the collection
o Return only the records that have both a title and a series title
o List the comics that have science fiction in their topics
o Return the title and average rating of each comic
o Return the title of comics that have had no ratings or comments

Update the title of comic 17118168 to “Batman and Superman”
Update all “Titan Comics” publisher to “Titan Comics Incorporated”
Add a new field called notes to the following comics:
o 16556832 Designed to be pulled apart and filed in special binders
o 17035085 A free gift accompanies each issue
o 17593604 Each issue is accompanied by gifts

For the report you are required to explain the structure of the database you created.This includes justifying the indexes you created. You need to describe how the relationships were handled in the database. In your report, discuss potential
alternatives to how the relationships could have been modeled and implemented in MongoDB and the benefits/issues of each. Provide recommendations to Comic Crusaders for any additional functionality for the database.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 5 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). ICT704 Non Relational Database Systems. Retrieved from https://myassignmenthelp.com/free-samples/ict704-non-relational-database-systems/books-retailer.html.

"ICT704 Non Relational Database Systems." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/ict704-non-relational-database-systems/books-retailer.html.

My Assignment Help (2021) ICT704 Non Relational Database Systems [Online]. Available from: https://myassignmenthelp.com/free-samples/ict704-non-relational-database-systems/books-retailer.html
[Accessed 06 February 2023].

My Assignment Help. 'ICT704 Non Relational Database Systems' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/ict704-non-relational-database-systems/books-retailer.html> accessed 06 February 2023.

My Assignment Help. ICT704 Non Relational Database Systems [Internet]. My Assignment Help. 2021 [cited 06 February 2023]. Available from: https://myassignmenthelp.com/free-samples/ict704-non-relational-database-systems/books-retailer.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?
close
Subtraction Payment required!

Only one step away from your solution of order no.