Lab 2: SQL Review

Course Number: DBM405A

Professor: Charles Bocage

Laboratory Number: 1

Laboratory Title: SQL Review

Submittal Date: 3/10/2019

Objectives: This lab was designed to install and open MySQL and to have deep understanding of the environment of database on computer.

Results:

First I created a database named “Baseball” then created a table named “Teams” , after populating the result will be as follow

After creating “Players” table and populating it with 80 entries the result is as follow

Conclusions:

After creating the database, two tables inside it and populating it with different entities different tables are produced. The screenshots of the produced tables are displayed above.