In class exercises

Part I - ER Diagram

1. Create ER Diagram for Amtrak Timetables

2. Create physical model for Amtrak Timetables

Part II - Normalization

3. Walk through MTA normalization example in slides

4. Time permitting, normalize cloud cover in weather data

https://www.postgresql.org/docs/9.4/static/functions-string.html

SELECT weather_id, split_part(skycondition, ':', 1) AS cov1,
substring(split_part(skycondition, ':', 2) from 1 for 2) AS okta1,
split_part(skycondition, ' ',2) AS bheight1
FROM nyc.weather_daily
ORDER BY weather_id DESC
LIMIT 100