Lab 1

Find a dataset of your choosing from the web. Some suggested places to look are: NYC Open Data, Kaggle datasets, or 35 brilliant and free data sources.

Exercises

  1. Download a dataset of your choosing
  2. Load the dataset into MySQL
  3. Look around the dataset using SQL SELECT commands
  4. Write a short description of the dataset including:
    • The source of the dataset
    • A description of the dataset (e.g., what is the dataset about)
    • A descripition of the attribute names and their type/domain
    • A screenshot of a SELECT * from your dataset in MySQL Workbench
    • Three interesting observations about the data.

Submission Instructions

Submit your write up as a pdf.