Eduvos Enrolment Database System

Enrolment department at Eduvos requires a new enrolment system and has therefore, contacted you to develop the 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 a single department. There are many modules offered at Eduvos, each with its own specialised instructor. Some instructors may have multiple modules. Modules are uniquely identified by a code $-$ the first three letters of its name, 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, subject allocation, exams schedule, and departmental operations, supporting academic excellence and administrative processes within the institution.

Source: Obaro Adewale $(2024)$

Note:

In this section, all questions must be answered using queries only, except the ERD. Hence, failure to write query for any of the question automatically will attract zero $(0).$

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

Any query written using other DBMS ide will automatically attract zero $(0).$

Questions for Consideration Under Deliverable $2$

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 entities and use this information to design an entity relationship diagram.

$(8$ Marks$)$

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

$(3$ Marks$)$

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

$(5$ Marks$)$

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

$(15$ Marks$)$

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

$(3$ Marks$)$

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

$(3$ Marks$)$

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

$(3$ Marks$)$

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

$(3$ Marks$)$

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

$(3$ Marks$)$

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

Note: Copy the JSON code and paste it into your submission.

$(4$ Marks$)$