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
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. Marks Create a database called EduEnrolment using query. Marks Create the identified five collections in the given scenario. Marks Store at least five records into each table collection based on the identified attributes into each entity. Marks Select all students STUDENT sorted by student name in ascending order. Marks Select all instructors INSTRUCTOR sorted by instructor identity in ascending and instructor name in descending order. Marks Write a query to obtain find the information of students STUDENT whose names begin with A Marks Update the MODULE collection by settingchanging 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. Marks 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, eg instructorID Marks 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
