Design an appropriate database, drawing an ER diagram and writing a database design outline. In each question below, assume that any "address information" specified is in US format, consisting of fields for street address, city, two-letter state code, and zip code. Unless stated otherwise in an individual problem, assume that you do not have the master zip code table in your databases, so that city, state, and zip code may be treated as independent. When the problems specify that you should store a "date/time," assume that you will store dates and times together in MS-Access-style "date/time" fields, which are able to store a date and time together in a single attribute.

1. Swim club membership records: Widevale swim club has been keeping its membership records in a spreadsheet, but this year the swim club board has decided to use a true database instead. Each membership consists of one or more people living at the same address. For each membership you need to record a membership "type code" (such as "regular," "senior," and "military discount") reflecting discounts for certain employ-ers, senior citizens, and so forth. The annual fee for the membership is determined by the type code. For each membership, you also want to store the date payment was received and address information. Each membership applies to all people residing at the registered address, and for each person covered by a membership, you wish to store a first name, middle name/initial, last name, gender, date of birth, phone number, and e-mail address.
2. Electric guitar repair: You operate a small business repairing electric guitars. For each of your customers, you want to store a first name, last name, phone number, and address information. A customer may have more than one instrument, but each instrument has just one owner. For each instrument, you want to store the maker, model, color, year made, and some comments. For each instrument, there may be one or more repair jobs. For each repair job, you want to store a description of work wanted, hours spent, dollars charged, the date/time the instrument was dropped off, the date/time you started work, the date/time you completed work, description of work actually done, and the date/time the instrument was picked up. Even if a customer drops off or picks up several instruments at once, they are considered different repair jobs.
3. One-person consulting business: You are a freelance consultant, working alone, and want to keep detailed records of the time you spend working for your clients. For each client, you want to store an ID number, name, address information, phone number, and e-mail address. Each client may have one or more jobs, each of which has a unique job ticket number, a description, an agreed hourly rate, and a yes/ no field indicating whether the job has been completed. You work on a particular job in one or more "work sessions": for each work session, vou want to store the date/time you started working, the date/time you stopped working, and a brief description of what you accomplished during that session. Some jobs may be completed in a single session, but others may require a large number of sessions spread out over a number of months.