DBM405A Lab 3 Baseball Database and Season Table

I. OBJECTIVES

  1. Understand and become familiar with Table Manipulation.

II. PARTS LIST

  1. EDUPE Omnymbus Environment (https://devry.edupe.net:8300); and/or
  2. MySQL (dev.mysql.com/downloads).

III. PROCEDURE
By now you have set up either the Omnymbus environment or the MySQL Server Community environment, or both. You may do the labs in this class on your own computer equipped with MySQL or you may use the MySQL environment hosted by the vendor Omnymbus. You may even use both.
Lab Procedure Continued (common to both environments)

  1. Add a table named “Season” to your Baseball database, which consists of the following fields:
    1. Season (Integer)
    2. PlayDate (date)
    3. HomeTeam (character 5)
    4. HomeTeamScore (Integer)
    5. AwayTeam (character 5)
    6. 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 already there.



This slideshow requires JavaScript.



This assignment includes a zip document.

  • Attachments
  • Preview random excerpt
    );
    xxxxxxxx xxxxxx;
    -- xxxx 2: xxxxxxxx xxxxxx xxxxx;
    xxxxxx xxxx xxxxxx xxxxxx
    (
    xxxx
    ,'2016-
    xx
    -01','
    xxxxx
    ','
    xxxxx
    ',
    xxxx
    ,
    xxxx
    ), (
    xxxx
    ,'
    xxxx
    -01-04','
    xxxxx
    ','
    xxxxx
    ', NULL ,
    xxxx
    ), (
    xxxx
    ,'
    xxxx
    -01-07','
    xxxxx
    ','
    xxxxx
    ',
    xxxx
    ,
    xxxx
    ), (
    xxxx
    ,'
    xxxx
    -01-10','
    xxxxx
    ','Team5', NULL , NULL ), ( 2016 ,'
    xxxx
    -
    xx
    -13','Team1','
    xxxxx
    ', NULL ,
    xxxx
    ), (
    xxxx
    ,'2016-
    xx
    -16','Team1','Team7', NULL ,
    xxxx
    ), (
    xxxx
    ,'2016-01-19','
    xxxxx
    ','
    xxxxx
    ',
    xxxx
    ,
    xxxx
    ), (
    xxxx
    ,'2016-01-
    xx
    ','
    xxxxx
    ','
    xxxxx
    ', NULL ,
    xxxx
    ), (
    xxxx
    ,'2016-01-
    xx
    ','Team2','Team3',
    xxxx
    ,
    xxxx
    ), (
    xxxx
    ,'
    xxxx
    -
    xx
    -28','Team2','
    xxxxx
    ', NULL , NULL ),
    ( 2016 ,'2016-01-31','xxxx2','xxxx5', xxxx , xxxx ),
    ( 2016 ,'2016-02-03','xxxx2','xxxx6', xxxx , xxxx ),
    ( 2016 ,'2016-02-06','xxxx2','xxxx7', xxxx , xxxx ),
    - - - more text follows - - -



Purchasing Instruction
List Price: $15
Buy Now

Buy More Save More
Buy at least TWO items & save up to 30% OFF your ENTIRE order!
Rack up instant rebates in your shopping cart. Simply add items to your cart, and see the savings add up.
Discounts will automatically be applied on eligible orders.

Add to Cart