Lab 3: Database Creation and Table Manipulation

Laboratory Report DeVry University College of Engineering and Information Sciences

Course Number: DBM405A

Professor: Charles Bocage

Laboratory Number: 2

Laboratory Title: SQL Review

Submittal Date: 3/17/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: In your own words, what was this lab designed to accomplish? What was its purpose?

Lab was designed to help students getting hands-on experience on the queries in databases including where clause, order by clause and group by clause. There is a sufficient level of explanation that how to proceed with the solutions.

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.

Part 6 To accomplish part 6 “Demonstrate the use of the WHERE clause by selecting and displaying only the players from one team.”. I displayed the players who belong to team 1. I used following query to get that done Query SELECT * FROM `players` WHERE Team='1' Result Following is the screenshot showing the query and the result of that query Part 7 Query SELECT Team as 'Team Number', Count(*) as 'Count of Players' FROM `players` group by Team Result Part 8 Query SELECT PCity as 'Player City', Count(*) as 'Count of Players' FROM `players` group by PCity Result Part 9 Query SELECT LastName, Team as 'Team Number' FROM `players` order by Team, LastName Result

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

In the end I can conclude this lab by saying that this is the best idea of getting the students on hands-on practices by giving them a partial assistance as it was given in the problem statements, So the students just do not stuck at a point, they learn new things and proceed. In a very short period of time I have learnt how to use where clause, group by clause, order by clause which was not possible without the assistance in the problem statement.

Student:			DBM405A
	Name		Program		Signature