CSCI235 Database System Implementation Task 3 (IT3) : MongoDB Queries & UML Sem 2, 2025

CSCI235 Overview 

This task involves the use of MongoDBfor: 

• Reverse engineering BSON documents 
• Writing queries for data retrieval and manipulation 
• Demonstrating understanding of hierarchical document structure 

All implementations and outputs must be submitted electronically via Moodle. 

Note: Submissions via email will be deletedand receive a mark of zero.

CSCI235 Submission Requirements 

You must submit the following three files in a single zipped folder:

Name your zipped file as: 

<YourUOWStudentNumber>-IT3.zip 
Upload the ZIP to Moodleunder the Implementation Task 3submission section. 

Preliminary Task (No marks) 
Download and run the script studentSeminar2.js: 
mongosh "mongodb://localhost:27017/myDB" --file 
"D:/mongoDBScripts/studentSeminar.js"

Verify data was loaded using: db.studentSeminar.find().pretty() No submission or report required for this task. 

Task 1: Reverse Engineering (1.0 mark) Instructions: 

1. Choose one documentfrom the studentSeminar collection. 
2. Draw its equivalent conceptual model in UML notation. 
3. State the MongoDB implementation techniqueused (e.g., one-to- many, embedded documents, etc.). Use UMLet or any UML drawing tool you prefer.