IS202 Database Systems (Spring 2011)

Lab. #6

Due date Mayt11th, 2011

Don't forget to bring a written (printed) copy of your work
Your work should contain the PSM functions/procedures as well as the outputs.

First two example for you to see mySQL function and procedure syntax

A. Write the following as PSM functions or procedures, as appropriate (using the World database):
1. Return the name of the capital city for a given country name.
2. Return the name of the country for a given city name.
3. Find (list) the languages for a given country name.
4. Find (list) the country names for a given language.

B. Write the following as PSM functions or procedures, as appropriate (using the Product, PC, ... database):
1. 9.4.2 a
2. 9.4.2 b
3. 9.4.2 c
4. 9.4.2 d

During the Lab hours:
1. You will be asked to turn in your written answers for the above queries
2. You will be asked to write one or two PSM function/procedure (very similar to the above queries)
3. Your performance will be graded for both step 1 (written work) and step 2 (query practice).