The purpose of this assignment is to familiarize yourself with database software.  Because of the complexity of the program, this assignment will be fairly short.  Submit your assignment as an email attachment through WEBCT.

Part A [easier] 9 pts.

1.  Create a new data base.  Call it Address Book (2 points)

2.  Create a table. Call this table Mailing List.   There are eight fields which are to be included in your mailing list:  mailing list ID, last name, first name, street address, town, state, zipcode, and email address, in this order.  Add ten people to your table. [note:  at least one of these people must be from your hometown] (3 points)

Your address book can be either fictitious or include real people.  It must include your name as the first name in the list.

3.  Create a simple query. The query should  identify everyone from your town. Include first name, last name, and email address's in the saved query.  Save the query as hometown friends. ( 3 points)

Part B [hard] 9 pts.

4.  Do Analysis Exercise #3, page 181, and answer all of the questions.