I. An overview of entity relationship diagrams:

A) Go to

http://www.umsl.edu/~sauterv/analysis/er/er_intro.html

and read through the text.

B) Take the data that I gave you at the end of the last lab, and try to develop a ERD diagram for it.

You can work together on this!

II. An overview of SQL:

A) Go to the following site:

http://www.firstsql.com/tutor2.htm

Read about the SELECT statement

B) Go to the following site:

http://sqlzoo.net/

Under the Tutorial Section, click on the link for SELECT.

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 IN SELECT.

Do problems 1a to 1c

C) Under section 2a "More Practice with Select":

Fix the code in sections 1a and 1b.

Do questions 2a - 2c

D) Under Section 3, "Sum and Count"

Do all the questions

E) Under Section 4 "Joins"

Do questions 1a - 1c

Fix the code in question 2a

Do questions 2b and 2c


REMEMBER THAT THE ANSWERS ARE AVAILABLE, BUT PLEASE TAKE SOME TIME TO
DETERMINE THE ANSWER FOR YOURSELF BEFORE LOOKING AT THE CORRECT CODE