Creating A SQL Db From The Kaggle Titanic Dataset, Instructions And Submission

User Manual:

Open the PDF directly: View PDF PDF.
Page Count: 3

DownloadCreating A SQL Db From The Kaggle Titanic Dataset, Instructions And Submission
Open PDF In BrowserView PDF
David Lawson
Assignment 3
AIT 580
Summer 2017
1.

Describe the contents of the dataset. Briefly explain/speculate what knowledge can be gained by analyzing
the data.
The dataset describes the passengers aboard the Titanic, once the largest ship in the world, and who
survived it’s infamous sinking. The dataset contains attributes on the passengers including age, sex,
and socio-economic status. The Titanic notoriously had too few lifeboats to account for all of its
passengers and many passengers did not survive it’s sinking. This lack of lifeboats led to new laws
and regulations around boating safety and the number of lifeboats required for each ship. By
analyzing this dataset we can draw insights into how each passengers personal attributes
contributed to their chance of surviving and if lifeboat priority was given to any particular grouping
of passengers.
2.

3.

For each variable in the dataset, describe its type and how to indicate its data type in SQL.

Create an SQL table to contain the data; use the SQL "DESCRIBE" command to display the table
characteristics.

4.

Insert rows of data into the table; display what you entered using the SQL "SELECT" command.

5.

Write SQL commands that find the following:
a. how many total passengers are in the data set? how many died/survived?

b.

how many men and how many women survived?

c.

what is the average age of all passengers and of the survivors?

d.

what is the survival rate by Passenger Class?
Source Exif Data: 
File Type                       : PDF
File Type Extension             : pdf
MIME Type                       : application/pdf
PDF Version                     : 1.7
Linearized                      : Yes
Author                          : David Lawson
Create Date                     : 2017:06:24 22:59:37-04:00
Modify Date                     : 2019:02:04 20:49:03-05:00
Language                        : en-US
Tagged PDF                      : Yes
XMP Toolkit                     : Adobe XMP Core 5.6-c016 91.163616, 2018/10/29-16:58:49
Producer                        : Microsoft® Word 2016
Format                          : application/pdf
Creator                         : David Lawson
Creator Tool                    : Microsoft® Word 2016
Metadata Date                   : 2019:02:04 20:49:03-05:00
Document ID                     : uuid:63208B4F-B4BB-4707-8CBB-2A84E5766167
Instance ID                     : uuid:e456fb1a-bc88-4ba8-975c-c0e8a7185f6f
Page Count                      : 3
EXIF Metadata provided by EXIF.tools

Navigation menu