Lab 2: SQL Review
Laboratory Report DeVry University College of Engineering and Information Sciences
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.
|
Student: |
Agnes Galimah |
|
DBM405A |
|
Agnes Galimah |
|
|
Name |
|
Program |
|
Signature |