Assignment: Database Systems Implementation
Suppose that you are given a collection of JSON documents that represent a database of multiple choice exams taken by students.
Write mongoDB queries to answer the following questions:
1. Determine the total number of exams.
2. Determine the number of students that got questionid 34532
3. Determine the average grade of all students that took exam number 2 of 198:111 in the Fall of 2015.
4. For each (letter) grade determine the number of students that got that grade
5. For each question id determine its di?culty (number of times it was answered correctly/ number of times it was used in an exam).
The following json ?le is only an example to illustrate what the data looks like. The actual data has unique optionid and questionid.
Attachment:- Assignment Database Systems Implementation.rar