View the step-by-step solution to:

Laboratory Procedures DeVry University College of Engineering and Information Sciences I. OBJECTIVES 1. Understand and become familiar with Table...

  • Add a table named “Season” to your Baseball database, which consists of the following fields:
    • Season (Integer)
    • PlayDate (date)
    • HomeTeam (character 5)
    • HomeTeamScore (Integer)
    • AwayTeam (character 5)
    • AwayTeamScore (Integer)
  • 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.
  • Create another table called “PastSeasons” by copying the structure of the table “Season” and copying all the data from “Season” into the new table.
  • Replace the Season field in the table Season with next year for all records.
  • Unload the Season table data to a comma-delimited file.
  • Load the comma-delimited file to PastSeasons table, appending the data to the data that is already there.
Laboratory Procedures DeVry University College of Engineering and Information Sciences 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: 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 already there.
Background image of page 1

This question was asked on Jul 20, 2016 for the course DBM 405A at DeVry Chicago.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards