Question: 2 . 1 Identify the entities in the given scenario, establish the applicable relationships between the identified entities and use this information to design an

2.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.2 Create a database called EduEnrolment using query. (3 Marks)2.3 Create the identified five (5) collections in the given scenario. (5 Marks)2.4 Store at least five (5) records into each table (collection) based on the identified attributes into each entity. (15 Marks)2.5 Select all students (STUDENT) sorted by student name in ascending order. (3 Marks)2.6 Select all instructors (INSTRUCTOR) sorted by instructor identity in ascending and instructor name in descending order. (3 Marks)2.7 Write a query to obtain (find) the information of students (STUDENT) whose names begin with 'A'.(3 Marks)2.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.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.10 Download ALL the database tables (collections) in JSON format and submit them as portfolio of evidence for working with a document database.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!