Lab Procedure Continued (common to both environments)

1. Add a table named Season to your Baseball database, which consists of the following

fields:

a. Season (Integer)

b. PlayDate (date)

c. HomeTeam (character 5)

d. HomeTeamScore (Integer)

e. AwayTeam (character 5)

f. AwayTeamScore (Integer)

2. Populate the table with 56 unique games where each plays the other 7 twice (once as the

home team and once as the away team). Make the season equal to this year. Leave the

scores blank and use any date for the PlayDate.

3. Create another table called PastSeasons by copying the structure of the table Season

and copying all the data from Season into the new table.

4. Replace the Season field in the table Season with next year for all records.

5. Unload the Season table data to a comma-delimited file.

6. Load the comma-delimited file to PastSeasons table, appending the data to the data that is