CS122, Spring 2004

Due: Thursday, May 27

Please send the solutions to csun@calstatela.edu by email. Make sure to use CS122 Spring 04 HW4 as the subject of the email, and include in the email your name so I don't have to guess names from email addresses.

0. Read Chapter 3 and Chapter 7 of the textbook.

1.(5pt) Continue with the last problem of Lab 7 and verify the second part of De Morgan's Law: the complement set of A intersection B is the union of A's complement set and B's complement set.

Use Books.mdb for the following problems:

2. Update queries

(a) (5pt) Use CREATE TABLE statement to create a table

(b) (2pt) Use INSERT INTO ... SELECT to populate

(c) (5pt) We finally found out that the missing first name of Kellsey is "Buttford". Write a query to update the information in

(d) (2pt) Add a new column

(e) (8pt) The email of an author is in the form: first letter of first name in lower case, last name in lower case, @hotmail.com. e.g. Sarah Buckman's email address would be sbuckman@hotmail.com. Write a query to fill in the email information in

(f) (8pt) The area code 415 in San Francisco has changed to 475. Write a query to update the information in

3. (5pt) Find the name(s) of the publisher(s) that have not published any book.

4. (5pt) List the author name and the total number of pages in books written by each author. [Abbott]

5. (5pt) Find the name(s) of the author(s) who wrote the greatest number of books. [Abbott]