Assignment One
Boolean Expressions and SQL: Due 9/27/13
A) Go to the following site:
http://www.firstsql.com/tutor2.htm
Read about the SELECT statement
B) Go to the following site:
1) Under the Tutorial Section,
click on the link for "Select Basics"
Work through the problems - be sure to click on the blue links for more infomation
When you are done with this, go to the click on the section "Select from World"
and do problems 2 and 3.
2) Under section "Select within Select", do problems 2 and 3.
C) Answer the following questions, based on what you did:
1) What is SQL? What does the
SELECT statement do?
2) What are the strengths of using the SELECT statement? What are its limitations?
3) How, in your view, would you "modify" commands like the SELECT statement to overcome any limitations that you mentioned in your answer to the previous question?