Exercise 8
CS122, Spring 2004

Thursday, May 20

Chapter 3

1.(20pt) Chapter 3  Ex 1, 4, 5

NOTE:

- All operations should be performed using SQL statements, with the exception of Ex 1(a) and Ex 5(g).

- For Ex 1(a), create the table using CREATE TABLE statement, however, you may need to use NUMBER as the type of the balance field, and later change the type to DECIMAL in the Design View. Use precision 5 and scale 1 for the DECIMAL type.

- For Ex 1(c), also try following values for the balance field: 1234567, 235.333, and 127.555.

- For Ex 4(c), delete all tuples with balance below average balance.