Securing Higher Grades Costing Your Pocket? Book Your Coursework Help at The Lowest Price Now!

  • +1-617-874-1011 (US)
  • +44-117-230-1145 (UK)
Online Customer Service

ICT704 Non Relational Database Systems-Comic Crusaders Books Retailer

Answer:

Comic Crusaders are one of the largest comic books retailer having presence in United States (US) and United Kingdom (UK) who wish to have online presence in the current market. For each book they wish to store the customer’s feedback. Only those customers can provide the feedback who register their name with Comic Crusaders. MongoDB database is being used to store the details like comics, publishers and reviews & ratings. (Anon., 2015).

Like other RDBMS, MongoDB is non-relational. Tables of RDBMS are represented as collection and rows are represented as fields in MongoDB.

Database with the following structure has been created:

Database name:   “comiccrusaders”

Collection Name: “comics”  

Colletion comics have the following fields:


comicid

Each comic is recognized by this field and it is compulsory. It cannot be null.

title

Title of the comic.

seriestitle

Series of the title e.g. Disney kingdoms. (if any). It can contain a null value.

dateofpublication

It just stores the publication year of the comic and cannot be null.

physicaldescription

Physical description of the comic book. It is an optional field.

topics

Category or keywords of comic book. It is an optional field. Searching of a comic depends upon this field.

language

Comic books are presently available in English only. It cannot be null.

publisher

Detail of comic book’s publisher is stored e.g. publisher id, publisher name, place of publication and country.

reviews

Reviews& Ratings provided by the registered customers. e.g. reviewed by, date, rating and comments. Rating should be out of 10.

"_id" field is created by MongoDB by default to store ObjectId for every single comic.

Indexes in comiccrusaders

In current situation or scenario one index has been created by DB i.e. unique index on comicid for identification of each comic. It is created in ascending order by default. Comic records are easily maintained with all its relevant data. Due to assignment of comicid to each comic it is easy for retailer to fetch its data. (Anon., 2008)

By default, MongoDB creates unique index on _id field for allocation (memory) for each comic in the “comics” collection. (Anon., 2016)

Relationships in comiccrusaders

In comics, embedded relationship has been created. In this associated publisher’s details and reviews & ratings are embedded to the particular comic. In comics reviews are present for some comics and some of the comic(s) reviews are not present. If review is present then it will be displayed else only braces are displayed. In some cases multiple reviews are being stored for the comic but with different reviewID. In this type of relationship the data present is not in the normalized form. (Anon., 2011)

Alternative Modeling (Relationships)

In MongoDB relationships are handled or created by two different ways:

  • Embedded
  • Referenced

In comiccrusaders embedded relationship has been implemented but referenced approach implementation would be better approach. If we implement referenced approach it would be easy for Comic Crusaders to maintain the data in bulk. Data present in the referenced approach is basically in normalized form. In this ratings & reviews and publisher’s details should be stored in another collection. (França, 2015). We can have 3 collection:

  1. Comics – comicID, title, series title, date of publication, pubid, physical description, topics and language.
  2. Reviews – comicID, reviewed by, ratings and comments
  3. Publishers – pubID, publisher name, place of publication and country.

Isolate data that can be suggested from various spots into its own specific aggregation. If many records will suggest comparable data, it is more capable and less mix-up slanted to revive a single record and keep references to it in various spots. The use of reference approach requires an extra request for a read operation and therefore impact execution. In the referenced model the data is a relationship is the institutionalized shape. It can manage the considerable number of data. For information that should be rehashed crosswise over completed many documents, it can be useful to have them in their own specific unmistakable record. This can decrease messes up and help in keeping the information tried and true (while remembering that different record strengthens are not nuclear). (Nayak, 2016)

In addition, in the event that figure you're presented reports may beat the recording gage confine obliged by MongoDB, by then you'll have to store two or three information in free narratives.

The drawback of this approach is that brain boggling request is to be made for fulfilling the results. If any control like eradication is to be done by then looking at unobtrusive components from various collections ought to be deleted. (Anon., n.d.)

Recommendations to Comic Crusaders

In the wake of breaking down the necessity I might want to recommend or suggest various implementations to the retailer Comic Crusaders:

  • They should store the purposes of enthusiasm of their productive customers like customer name, address, mobile number and email.
  • They should demonstrate the examinations and reviews of the each comic book open.
  • They should in like manner consolidate funnies on another tongue.
  • Before circulating the reviews on the site they should coordinate the overviews given by the customers. In case of any objectionable reviews they should obsolete it and inform customers not to post such comments or reviews.
  • They should ensure that the funnies or comics are available to them.
  • Customers should give the evaluations and reviews to each comic they have examined.
  • Each comic should be stand-out.
  • Each merchant should be unique.
  • Implementation of the site should bid or essential.
  • Year of conveyance should be secured.
  • They should in like manner start giving the news and updates on their site including latest releases.
  • They should also introduce the new features in the site like customers can place an order online with payment made online or cash on delivery.
  • They should help the customers to track the delivery of their ordered comic.
  • Keywords for each comic should be secured so it is available through the web crawler.
  • Customers should have the ability to look through the funnies on the preface of the wholesalers for giving assessments and overviews.(Anon., 2017)

References

Anon., 2008. Indexes. [Online]
Available at: https://docs.mongodb.com/manual/indexes/

Anon., 2011. Model One-to-One Relationships with Embedded Documents. [Online]
Available at: https://docs.mongodb.com/manual/tutorial/model-embedded-one-to-one-relationships-between-documents/

Anon., 2015. Schema Basics. [Online]
Available at: https://learnmongodbthehardway.com/schema/schemabasics/

Anon., 2016. Indexing and Aggregation in MongoDB Tutorial. [Online]
Available at: https://www.simplilearn.com/indexing-and-aggregation-mongodb-tutorial-video

Anon., 2017. Embedded Documents. [Online]
Available at: https://mongoosejs.com/docs/2.7.x/docs/embedded-documents.html

Anon., n.d. Multiple Collections Versus Embedded Documents. [Online]
Available at: https://openmymind.net/Multiple-Collections-Versus-Embedded-Documents/

França, W. d. R., 2015. MongoDB Data Modeling. s.l.:s.n.

Nayak, A., 2016. MongoDB Cookbook. s.l.:s.n.

This problem has been solved.


Please send an Email to help@urgenthomework.com with the Payment ID and the link to the document to collect by email


Cite This work.

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

Urgent Homework (2022) . Retrive from https://www.urgenthomework.com/sample-homework/ict704-non-relational-database-systems-comic-crusaders-books-retailer

"." Urgent Homework ,2022, https://www.urgenthomework.com/sample-homework/ict704-non-relational-database-systems-comic-crusaders-books-retailer

Urgent Homework (2022) . Available from: https://www.urgenthomework.com/sample-homework/ict704-non-relational-database-systems-comic-crusaders-books-retailer

[Accessed 06/10/2022].

Urgent Homework . ''(Urgent Homework ,2022) https://www.urgenthomework.com/sample-homework/ict704-non-relational-database-systems-comic-crusaders-books-retailer accessed 06/10/2022.


Buy ICT704 Non Relational Database Systems-Comic Crusaders Books Retailer Answers Online

Talk to our expert to get the help with ICT704 Non Relational Database Systems-Comic Crusaders Books Retailer Answers to complete your assessment on time and boost your grades now

The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.

Get Online Support for ICT704 Non Relational Database Systems-Comic Crusaders Books Retailer Assignment Help Online

Resources

    • 24 x 7 Availability.
    • Trained and Certified Experts.
    • Deadline Guaranteed.
    • Plagiarism Free.
    • Privacy Guaranteed.
    • Free download.
    • Online help for all project.
    • Homework Help Services
Tap to Chat
Get Instant Assignment Help
Tap to Chat
Get Instant Assignment Help