Determine the total number of exams

Assignment Help Database Management System

Reference no: EM131967055

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

Reference no: EM131967055

Questions Cloud

How much could he withdraw at the beginning of each month : How much could he withdraw at the beginning of each month for the next 30 years and end up with zero in the account?

Determining the confidence intervals : In a trial of Pfizer's new math anxiety-reducing drug, Probstatin® , a random sample of 100 students yielded 58 who showed significant improvement.

Research on project management practice : MN601 - Network Project Management - Individual case study assignment -

How you would present the information to senior managers : Examine the best practices that your team can cultivate to enhance the number of millennial leaders. Explain how you would present this information to senior.

Determine the total number of exams : Determine the total number of exams. Determine the average grade of all students that took exam number 2 of 198:111 in the Fall of 2015.

Future value or compound amount : Calculate the FV (Future Value) using the "Future Value or Compound Amount of $1.00" table in your textbook.

Use the afn equation to forecast the additional funds : Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year.

Quarterly rate would be equivalent to rate charged by bank : What nominal quarterly rate would be equivalent to the rate charged by the bank?

Identify the primary security risks and threats : Determine the severity level of the risks and threats in terms of likelihood and impact on the business.

User Account

All Pages