Assignment: Database Creation And Table Manipulation
Scenario/Summary
Download the Lab instructions and the Lab report for the necessary steps to be completed for this lab. They can be found in the Files section of the Course Menu under the Lab category. Complete this template Lab report document by completing the sections listed on the page (Objectives, Results, and Conclusions). You will notice that the readings, including lectures, the examples we worked on during the lecture, and other audio and visual aids provided, will help you tackle this week's lab. Remember to always follow the instructions to get maximum credit, and use the weekly discussion related to the Lab and the Course Q & A Forum in the Introduction and Resources module for additional help. Be specific and state the problem you are having clearly, including what you have done to resolve it, in the discussion.
Required Software
This Lab will use the following Lab Resources:
Microsoft Office: Word
MySQL
Use a personal copy of the software or access Lab Resources under Introduction and Resources > Course Resources and view the Lab Resourcessection.
Lab Steps
Step 1: Creating the First Procedure
The report cover sheets must be completed for all labs. The key parts of these sheets include the following.
• Objective: Provide a one- or two-sentence explanation of the purpose of the lab.
• Results: Give a statement of the final output, such as what will make this lab successful.
• Conclusions: Conclusions should be based on the results usually directly related to the purpose of the lab.
• Observations and Measurements: All results from the lab must be recorded on the cover sheets. Turn in the cover sheets for grading and retain the remainder of the lab as worksheets.
I. OBJECTIVES
1. Understand and become familiar with Table Manipulation.
II. PARTS LIST
1. EDUPE Omnymbus Environment; and/or
2. MySQL.
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.
Note: There is no limit on how much information you will enter under the three topics below. It is important to be clear and complete with your comments. Like a scientist, you are documenting your progress in this week's lab experiment.
Objectives: In your own words, what was this lab designed to accomplish?What was its purpose?
Results: Discuss the steps you used to complete your lab. Were you successful? What did you learn? What were the results? Explain what you did to accomplish each step. You can include screen shots, code listings, etc. to clearly explain what you did.
Conclusions: After completing this lab, in your own words, what conclusions can you draw from this experience?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- AG-Lab.rar