Problem 1:

San Juan Sailboat Charters (SJSBC) is an agency that leases sailboats. SJSBC does not own the boats. Instead, SJSBC leases boats on behalf of boat owners who want to earn income from their boats when they are not using the boats themselves, and SJSBC charges the owners a fee for this service. SJSBC likes to keep accurate records of its customers and charters, and customers are required to keep a log during each charter. Below is a sample list of owners and boats.

1. Describe specific problems that are likely to occur when inserting, updating, and deleting data in the spreadsheet above.

e.g., if I update column X in list Y, the problem is ...

2. Split the table into two tables such that each has only one theme, without loosing information.

3. Explain how the tables in your answer to Part 2 will eliminate the problems you identified in Part 1.

4. Using the 2 tables you designed in Part 3, how should I look for answers to the following questions? For each question, specify (1) the names of the tables which I should look up, (2) the precise information I should look up in each table, and (3) the order in which these tables should be looked up.

(a) How many boats were owned by Bill Tulsa?

(b) How many boat owners live in Oregon state?

(c) The models of boats owned by an owner whose phone number is 503-578-7574?

Table 1: Boat_0mner Table