Question: Question Three (25 marks) Use the sample below from the incident document database collection to answer the following questions: (assume the database name is: db

 Question Three (25 marks) Use the sample below from the incident
document database collection to answer the following questions: (assume the database name

Question Three (25 marks) Use the sample below from the incident document database collection to answer the following questions: (assume the database name is: "db" and the collection name is: 'event'). Explain the answer in your own words. "event_id":"EV141", "details": { "type_code":"COMP", "name":"Painting competition", "category":"Children below 10 years old" } "event_startdate":"ISODate("2021-11-21T08:00:00z"), "event_enddate": "ISODate("2021-11-21T10:00:002") "coordinators":[ {"civil_id":"600","person_name":"amani"}, {"civil_id": "1100","person_name":"arwa"} 1. "event_location":"UAE" } Time left 1:57:38 "event_enddate": "IsDate("2021-11-21T10:00:002"), "coordinators": ("civil_Id":"600","person_name":"amani"), ("civil_id":"1100","person_name":"arwa") 1, "event_location":"UAE" > a. Find all documents in the event collection b. Find any document from the event collection where the event location is 'UAE. c. Find the event documents in which coordinator with civilid 100 is involved d. Find the number of events with the event type code 'COMP in the collection Find all the details of events where the end date is before 30-10-2021 13 marks) 15 Marke) 15 marks) lo marks) 16 markol

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!