All queries in this section must be written in MongoDB platform only.

Enrolment department at Eduvos requires a new enrolment system and has therefore, contacted you to developthe database system for them. The database will keep records of the company$$s departments, instructors, modules, and students.

Each department at Eduvos has multiple instructors working under it$,$ though an instructor may only work in asingle department. There are many modules offered at Eduvos, each with its own specialised instructor. Someinstructors may have multiple modules. Modules are uniquely identified by a code $$ the first three letters of itsname, followed by an auto$-$incremented number.

The classes at Eduvos are limited to at most fifty $(50)$ students, who should have an average of ten $(10)$ modules per year. Students are uniquely identified by their student numbers and all their details are stored on the system. The implementation of the above database design will facilitate efficient management of students, subjectallocation, exams schedule, and departmental operations, supporting academic excellence and administrativeprocesses within the institution.

All queries in this section must be written in MongoDB platform only.

Use the above scenario to answer the following questions:

$2\mathrm{.}1$ Identify the entities in the given scenario, establish the applicable relationships between the identified entitiesand use this information to design an entity relationship diagram.

$2\mathrm{.}2$ Create a database called EduEnrolment using query.

$2\mathrm{.}3$ Create the identified five $(5)$ collections in the given scenario.

$2\mathrm{.}4$ Store at least five $(5)$ records into each table $($collection$)$ based on the identified attributes into each entity.

$2\mathrm{.}5$ Select all students $($STUDENT$)$ sorted by student name in ascending order.

$2\mathrm{.}6$ Select all instructors $($INSTRUCTOR$)$ sorted by instructor identity in ascending and instructor name indescending order.

$2\mathrm{.}7$ Write a query to obtain $($find$)$ the information of students $($STUDENT$)$ whose names begin with $\text{'}$A$\text{'}.$

$2\mathrm{.}8$ Update the MODULE collection by setting$/$changing any of its existing records to a new value and display therecords in the MODULE collection to confirm the effect of the update operation.

$2\mathrm{.}9$ Due to dynamic working requirements at Eduvos, an instructor resigned and ought to be deleted. Create aquery capable of deleting the record of the instructor who resigned to prevent data inconsistency. Use anyinstructor ID of your choice, e$.$g$.$ instructorID $50001.$

$2\mathrm{.}10$ Download ALL the database tables $($collections$)$ in JSON format and submit them as portfolio of evidence forworking with a document database.