Question: I need help with the MongoDB portion : Load these data in a relational database (e.g., PostgreSQL), a graph database (e.g., Neo4j), and a document

I need help with the MongoDB portion :

Load these data in a relational database (e.g., PostgreSQL), a graph database (e.g., Neo4j), and a document database (e.g., MongoDB).Your goal is to determine the median and average accident severity for each type of motorcycle. Write the queries to find the median and average accident severity for each type of motorcycle. Show the results of these queries.

From the Accidents.csv file:

AccidentSeverity the code for the severity of the accident.

AccidentIndex a unique identifier for the accident.

From the Make_Model.csv file:

AccidentIndex unique identifier for the accident.

VehicleType the vehicle code for the vehicle involved in the accident.

From the Vehicles.csv file

code the vehicle code

label the corresponding vehicle type for this code

I have loaded the data in, now i need help with the join statement and the average and median accident severity for each type of motorcycle i.e. vehicle label from the vehicles table must contain the word motorcycle.

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!