Lab 4: Tables and Indexes

Laboratory Report DeVry University College of Engineering and Information Sciences

Course Number: DBM405A

Professor: Charles Bocage

Laboratory Number: 3

Laboratory Title: Database Creation and Table Manipulation

Submittal Date: 3/24/2019

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: This lab is designed to accomplish hands on data handling using MySQL.

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.

First I entered 56 entries in the table Season.

Following is the screenshot of 56 entries in Season table

Following is the screenshot when all data is copied in PastSeasons table

Following is the screenshot after changing year in PastSeasons table.

Following is the generated csv file of table season

After loading season.csv in Pastseasons table

Conclusions: After completing this lab, in your own words, what conclusions can you draw from this experience?

This lab meant to be very informative for me as it gave very clear idea about the data handling in MySQL.

Student:
	Name		Program		Signature

References

Generatedata.com. (2019, March). Retrieved March 24, 2019, from http://www.generatedata.com/

University, D. (2019, March). Re: Class Discussion [Web log comment]. Retrieved March, 2019.