Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started