ICT704
Non-Relational Database Systems
Task 2
NoSQL Database Assignment
Using MongoDB
ICT704 Non-Relational Database Systems
Task 2
Assessment and Submission Details
Marks: 40% of the Total Assessment for the Course
Due Date: Week 12
Submit your assignment in the link under Assessment->Task 2 on Blackboard. The
submission link will be open a week before the due date. Please follow the submission
instructions provided.
The assignment will be marked out of a total of 100 marks and forms 40% of the total
assessment for the course. ALL assignments will be checked for plagiarism by
SafeAssign system provided by Blackboard automatically.
Refer to your Course Outline or the Course Web Site for a copy of the “Student
Misconduct, Plagiarism and Collusion” guidelines.
Assignment submission extensions will only be made using the official Faculty of Arts
& Business Guidelines.
Requests for an extension to an assignment MUST be made to the course coordinator
prior to the date of submission and requests made on the day of submission or after
the submission date will only be considered in exceptional circumstances.
ICT704 Non-Relational Database Systems
Task 2
Background
Movie Maniacs is a site which lists top charts of movies and have put an emphasis in
follower engagement. They are active on Facebook and Twitter and share the latest
updates and news to their followers. However, they have recently decided to create a
page where viewers can rate the movies on the list and leave comments for others to
see. They have asked you to come up with a database using MongoDB to be able to
store their movie lists and allow viewers to easily rate and review the movies.
Movie Details
•
•
•
•
•
•
•
Every movie has a unique identifier
Some movies have a series title
Every movie has at least one Director and a list of leading actors
Some movies have won Oscars
Movies can have multiple reviews, one review or no reviews made
Reviews are made by anyone, who only need to supply a name
Reviews consist of a rating out of 10 and any comments
There are two parts to this assignment. Part A is the creation of the database in
MongoDB and Part B is the report.
Part A - Database
• Create a MongoDB database using the data provided to you in the
MovieData_Task2.xls spreadsheet. (There should only be one collection movies
with each movie 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 (all output should be displayed in a formatted way):
o List all the movies in the collection
o List the movies that are from Japan
o List just the directors name(s) for every movie
o List the distinct names of every director
o Count the number of movies in the list
o Return only the movies that have won at least one Oscar
o List the movies that were released before 1980
o Return the title and average rating of each movie
o Return the title of movies that have had no ratings or comments
• Update the title of movie 6 to “E.T.”
• Add a new field called notes to the following movies:
o 12 Terminator and Terminator 2 are rated together
o 18 The trilogy consists of the three movies
ICT704 Non-Relational Database Systems
Task 2
Part B - Report
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 Movie
Maniacs for any additional functionality for the database.
Specific Instructions
For Part A you are to submit a single plain text file, named
_mongoDB.txt.
In this file you are to include all the commands for your implementation.
For Part B you are to submit a report in a word document or PDF.
Submission
The completed assignment is to be submitted to Blackboard by the due date.
The assignment will be assessed according to the marking sheet. Late submission will
be penalised according to the policy in the course outline. Please note Saturday and
Sunday are included in the count of days late.
Appendix A
Marking Sheet for ICT704 Task 2
Student Name:
Student ID:
Maximum
Marks
Items
PART A: Database Implementation (65 marks made up of)
Create a MongoDB database (5 marks)
Insert data into MongoDB using the insert command (5 marks)
Create indexes (5 marks)
Create the queries and other actions (50 marks total)
65
PART B: Report (35 marks made up of)
o Database description (10 marks)
o Alternative modeling discussed (10 marks)
o Justification of indexes chosen (10 marks)
o Recommendations (5 marks)
35
Total =
Marks
Obtained
100
/40%
OVERALL COMMENTS:
MovieID MovieName
1
2001
2 Metropolis
3 Blade Runner
4 Alien
5 The Wizard of Oz
6 ET
7 Solaris
8 Spirited Away
9 Star Wars (1977)
10 Close Encounters
11 King Kong
12 Terminator/Terminator 2
13 The Matrix
14 Alphaville
15 Back to the Future
16 Planet of the Apes
17 Brazil
18 The Lord of the Rings trilogy
19 Dark Star
20 Day the Earth Stood Still
21 Edward Scissorhands
22 Akira
23 Princess Bride
24 Pan’s Labyrinth
25 Starship Troopers
Director
Stanley Kubrick
Fritz Lang
Ridley Scott
Ridley Scott
Victor Fleming
Steven Spielberg
Andrei Tarkovsky
Hayao Miyazaki
George Lucas
Steven Spielberg
Ernest B Schoedsack, Merian C Cooper
James Cameron
Andy & Larry Wachowski
Jean Luc-Godard
Robert Zemeckis
Franklin J Schaffner
Terry Gilliam
Peter Jackson
John Carpenter
Robert Wise
Tim Burton
Katsuhiro Otomo
Rob reiner
Guillermo del Toro
Paul Verhoeven
Leading actors
Daniel Richter, Gary Lockwood, Keir Dullea, William Sylvester
Alfred Abel, Brigitte Helm, Gustav Frohlich, Gustav Fruhlich
Harrison Ford, Rutger Hauer, Sean Young
Ian Holm, John Hurt, Sigourney Weaver, Tom Skerritt
Bert Lahr, Frank Morgan, Jack Haley, Judy Garland, Ray Bolger
Dee Wallace, Drew Barrymore, Henry Thomas, Peter Coyote
Donatas Banionis, Juri Jarvet, Nataly Bondarchuk, Natalya Bondarchuk
Daveigh Chase, Jason Marsden, Jason Marsdon, Mari Natsuki, Miyu Irino, Rumi Hiragi, Suzanne Pleshette
Alec Guinness, Carrie Fisher, David Prowse, Harrison Ford, Mark Hamill, Peter Cushing, Peter Mayhew
Melinda Dillon, Richard Dreyfuss
Bruce Cabot, Ernest B Schoedsack, Fay Wray, Frank Reicher, James Flavin, John Armstrong, Noble Jhonson, Robert Armstrong
Arnold Schwarzenegger, Linda Hamilton, Michael Biehn
Carrie-Anne Moss, Keanu Reeves, Laurence Fishburne
Anna Karina, Eddie Constantine
Christopher Lloyd, Crispin Glover, Lea Thompson, Michael J Fox
Charlton Heston, Kim Hunter, Roddy McDowell
Jonathan Pryce, Michael Palin, Robert De Niro
Cate Blanchett, Dominic Monaghan, Elijah Wood, Hugo Weaving, John Rhys-Davies, Liv Tyler, Miranda Otto, Orlando Bloom, Sean A
Brian Narelle, Dan O'Bannon, Dre Pahich
Hugh Marlowe, Lock Martin, Michael Rennie, Patricia Neal
Dianne Wiest, Johnny Depp, Winona Ryder
Mitsuo Iwata, Nozomu Sasaki, Mami Koyama, Tessho Genda
Billy Crystal, Carty Elwes, Cary Elwes, Mandy Patinkin, Peter Falk, Robin Wright
Ariadna Gil, Doug Jones, Ivana Baquero, Maribel Verdu, Sergi Lopez
Casper Van Dien, Clancy Brown, Dina Meyer, Jake Busey, Michael Ironside
ReleaseDate OscarsWon
1968
1927
1982
1979
1939
1982
1972
2001
1977
1977
1933
1984/1991
1999
1965
1985
1968
1985
2001-2003
1974
1951
1990
1988
1987
2006
1997
Country
1 USA
Germany
USA
1 USA
2 USA
4 USA
USA
1 Japan
6 USA
1 USA
USA
4 USA
4 USA
France
1 USA
1 USA
UK
17 New Zealand
USA
USA
USA
Japan
USA
3 Spain
USA
MovieID
1
2
3
1
5
7
8
9
11
11
20
18
18
21
ReviewedBy
Joe
Sam
Sandy
Howie
Jon
Jess
Amanda
Manni
Mitch
Matt
Lynda
Eve
Stuart
Carly
Date
Rating Comments
6/15/2018
9 The best ever!
6/12/2018
8
6/11/2018
10 Couldn't stop watching
6/9/2018
7
6/10/2018
9 Well written
6/1/2018
8
6/13/2018
9 Amazing.
6/11/2018
8
6/9/2018
5 Was ok, could have been better
6/7/2018
9 Brilliant
6/5/2018
10 Loved it
6/13/2018
10 Such a great trilogy
6/11/2018
6
6/8/2018
9 Wow! Loved it.
Purchase answer to see full
attachment