CREATE Statements

  1. Get the ERD from me
  2. Review the changes from the notes yesterday (I made a couple mistakes and a couple changes)
  3. Run the CREATE TABLE statements in APEX

INSERT Statements

  1. Roll the die to get your division
    1. NL East
    2. AL East
    3. NL Central
    4. AL Central
    5. NL West
    6. AL West
  2. You each have five teams in your division
  3. Search the internet for "SQL INSERT Statements" and you'll get a lot of info
  4. Write the INSERT statements to add the data into your database, all of the data should be on your team's website, which can be reached through MLB.com
    1. Add stadium info to STADIUM table
    2. Add team info to TEAMS table
    3. Look at the seating map for your stadium, add 6 different sections' info into the Sections table, you don't have to do the whole stadium
    4. Add 10 games into your table, these should be between only teams in your division, use real data from teams schedule. You should have a variety of teams, not all the same home team, even if they are your favorite.