Writer Required for Video Presentation
Budget: $30 – $250 USD
Task Overview:
This assignment will be undertaken by recording a talk and uploading it to Canvas. MP4 file uploads are requested. The presentation should contain audio and slides/video. You do not need a coversheet. Maximum Length of presentation should br 5 minutes.
Submission Requirements:
Please upload,
• A video or prerecorded slide show with audio.
• The slides of your presentation (as a separate file if necessary).
• Do not submit zip files (submit multiple files in the same submission instead, if necessary).
Module Name:
Big Data and Data Mining
Level of Study:
MSc
Budget:
Drop a Suitable Offer
Deadline:
14th March 2024
Software:
PowerPoint/ Depends on Task.
Information about the accident data:
The accident, vehicle and casualty tables contain data described in these webpages:
https://www.gov.uk/government/publications/road-accidents-and-safety-statistics-notes-and-definitions/reported-road-casualties-in-great-britain-notes-definitions-symbols-and-conventionsLinks to an external site.
https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/995422/stats19.pdfLinks to an external site.
Information about the LSOA regions (including a map)
The lsoa table contains data described here:
Lower layer Super Output Areas (December 2001) EW Population Weighted Centroids | Lower layer Super Output Areas (December 2001) EW Population Weighted Centroids | Open Geography Portal (statistics.gov.uk)Links to an external site.
Task:
Imagine you are a data scientist recently hired by the government to demonstrate the new SQL database you have created. Imagine the government is also planning on storing names of people involved in accidents. You produced a relational database in SQL. In your presentation you should
Introduce the potential technical, ethical and legal issues of storing the data. How might an SQL relational database address some of these?
Present and describe an entity-relationship diagram (ER diagram) for the database. There are a lot of columns in each table, so do not show them all. Just show primary keys, any foreign keys and a representative sample of 2 or 3 of the other columns.
Present SQL commands for the following, using the full data set from all years
The age of the oldest driver/rider in the casualty table
The total number of vehicle_type = 19 vehicles in the vehicle table
The sex of driver, sex of casualty, speed limit and age of vehicle for accidents in all the lower layer super output area (LSOA) regions of Kingston Upon Hull. You will need to do a JOIN on the lsoa table and some of the other tables. In the LSOA table, the codes are in the column lsoa01cd and the place names are in column lsoa01nm. Put the results in a pandas data frame.
You should show the SQL commands you ran and the results. For part ‘c’ just show a sample of the results and the total number of rows. You should also give some explanation for the more complex parts of the SQL commands you present.
This assignment will be undertaken by recording a talk and uploading it to Canvas. MP4 file uploads are requested. The presentation should contain audio and slides/video. You do not need a coversheet. Maximum Length of presentation should br 5 minutes.
Submission Requirements:
Please upload,
• A video or prerecorded slide show with audio.
• The slides of your presentation (as a separate file if necessary).
• Do not submit zip files (submit multiple files in the same submission instead, if necessary).
Module Name:
Big Data and Data Mining
Level of Study:
MSc
Budget:
Drop a Suitable Offer
Deadline:
14th March 2024
Software:
PowerPoint/ Depends on Task.
Information about the accident data:
The accident, vehicle and casualty tables contain data described in these webpages:
https://www.gov.uk/government/publications/road-accidents-and-safety-statistics-notes-and-definitions/reported-road-casualties-in-great-britain-notes-definitions-symbols-and-conventionsLinks to an external site.
https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/995422/stats19.pdfLinks to an external site.
Information about the LSOA regions (including a map)
The lsoa table contains data described here:
Lower layer Super Output Areas (December 2001) EW Population Weighted Centroids | Lower layer Super Output Areas (December 2001) EW Population Weighted Centroids | Open Geography Portal (statistics.gov.uk)Links to an external site.
Task:
Imagine you are a data scientist recently hired by the government to demonstrate the new SQL database you have created. Imagine the government is also planning on storing names of people involved in accidents. You produced a relational database in SQL. In your presentation you should
Introduce the potential technical, ethical and legal issues of storing the data. How might an SQL relational database address some of these?
Present and describe an entity-relationship diagram (ER diagram) for the database. There are a lot of columns in each table, so do not show them all. Just show primary keys, any foreign keys and a representative sample of 2 or 3 of the other columns.
Present SQL commands for the following, using the full data set from all years
The age of the oldest driver/rider in the casualty table
The total number of vehicle_type = 19 vehicles in the vehicle table
The sex of driver, sex of casualty, speed limit and age of vehicle for accidents in all the lower layer super output area (LSOA) regions of Kingston Upon Hull. You will need to do a JOIN on the lsoa table and some of the other tables. In the LSOA table, the codes are in the column lsoa01cd and the place names are in column lsoa01nm. Put the results in a pandas data frame.
You should show the SQL commands you ran and the results. For part ‘c’ just show a sample of the results and the total number of rows. You should also give some explanation for the more complex parts of the SQL commands you present.