Scope

This laboratory includes two tasks related to the implementation of queries and data manipulations on a collection of documents stored in MongoDB database. I have decided to combine Implementation Task 3 and Implementation Task 4 into one implementation task.

This Implementation is due by Thursday, 21 November 2024, 9:00 pm Singapore time. This task is worth 10% of the total assessment for the subject.

Only electronic submission through Moodle at: https://moodle.uowplatform.edu.au/ is accepted. All email submission will be deleted and mark 0 (“zero”) will be awarded.

For all the implemented tasks, your report or output must include a listing of all JSON scripts and its output.

The submission procedure is explained at the end of this specification.

Specification

Preliminary Task

For this task, you may choose to use either a virtual machine running MongoDB Enterprise Edition 3.6.5 or your own local installation of MongoDB.

1.  Download the file studentSeminar2.js from the SAMPLE DATABASE section on Moodle.

2. Open the MongoDB command line interface (CLI).

3. To create the sample database, run the following command: load('studentSeminar.js'). This will generate a collection containing student seminar enrollment data.

4. Verify the data by running the command: db.studentSeminar.find().pretty().

No report submission is required for this task.

Tasks

Task 1 (2.0 marks) Reverse Engineering

1.  Select a document from the studentSeminar sample collection.

2.  Using UML notation, create an equivalent object diagram to represent the document.

3.  Identify the implementation technique used for the document (e.g., one-to-one association, one-to-many  association) based on the BSON Design  techniques discussed in Topic 17.

4. You may use UMLet or any other UML drawing tool you have installed to create your conceptual model.

(2.0 marks)

Deliverables

Submit a file solution1.pdf containing the object diagram of the document in UML notation. Please put your UOW student number and name in all your solution.

Task 2 (8.0 marks)

MongoDB Data Manipulation

Use the data  manipulation  language  of  MongoDB  database  system  to  process  the following requirements:

a) Find all seminars whose description is "In-memory Database.". (1.0 mark)

b) Find total number of seminars the student std009 have enrolled in. (1.0 mark)

c)  Find the details of all seminars that have students received marks higher than 80.

(1.0 mark)

d) Find the details of all 3 credit points seminars that the student Sharon Smith has attended. You MUST use conjunction operator to implement this query. (1.0 mark)

e) Insert a new seminar to the studentSeminar collection. The detail of the seminar is as followed:

SeminarID : sem006,

Seminar Description : Attending Online Course, Seminar Date : 12-November-2024,

Credit Point : 2

(1.0 mark)

f)  Change the seminar date of seminar sem006 to 18 November 2024. (1.0 mark)

g) Add a student's enrolment to the studentSeminar collection. The student is enrolled to attend the seminar sem006 on 12 November 2024. The detail of the student is as follow:

studentID: std006

student name: Ofelia Ashley address: 123, Bukit Timah

telephone: [ handphone: 93858134, residentphone: 64352893 ] enrol to: sem002

mark received: 0

enrolment Date: 12-November-2024

Note: You can leave the mark received as 0 because the mark is not available yet.

(2.0 marks)