DBM405A Lab 4 NextSeason Season Tables Indexes and Report

I. OBJECTIVES

  1. Understand and become familiar with Tables and Indexes.

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. Create another table called “NextSeason” by copying the structure of the table “Season” and copying all the data from “Season” into the new table.
  2. Change the structure of “NextSeason” by adding the following field:
    1. Innings (Integer)
  3. Change the structure of “PastSeasons” by adding the following field:
    1. Innings (Integer)
  4. Delete the table “Season”.
  5. Rename the table “NextSeason” to “Season”.
  6. Create an index on the table “Teams”, indexing on “TeamCode”.
  7. Create an index on the table “Players”, indexing on “Team”.
  8. Based on the indexes, create a report or display of each team and the associated players on each team.



This slideshow requires JavaScript.



This assignment includes a zip document.

  • Attachments
  • Preview random excerpt
    xxxxxxxxxxxxx xxx xxxx
    );
    xxxxxxxx xxxxxxxxxx;
    -- xxxx xxx xxxx
    xxxxxx xxxx xxxxxxxxxx
    SELECT *
    xxxx
    Season;
    xxxxxx
    * FROM Season; --
    x
    ALTER TABLE NextSeason ADD
    xxxxxx
    xxxxxxx
    INT NULL; DESCRIBE NextSeason; --
    x
    xxxxx xxxxx xxxxxxxxxxx
    xxx xxxxxx xxxxxxx xxx xxxx;
    xxxxxxxx xxxxxxxxxxx;
    - - - 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