Looking For SQL Database Presentation Expert
Budget: $10 – $30 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 cover sheet. The maximum Length of presentation should be 3 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.
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 the 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.
We have a ready-made SQLite database containing the required tables. This presentation should demonstrate your knowledge of SQL and databases.
Thank you!
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 cover sheet. The maximum Length of presentation should be 3 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.
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 the 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.
We have a ready-made SQLite database containing the required tables. This presentation should demonstrate your knowledge of SQL and databases.
Thank you!