Question

Miller Sailboat Charters is an agent that leases sailboats to customers for a fee. Miller does not own any sailboats but instead leases them on behalf of boat owners who wish to earn income when they are not using their boats. Miller charges a fee for its service, and it specializes in boats that can be used for multi-day or weekly charters. The smallest sailboat is twenty-eight feet long, and the largest is forty-four feet long. Each sailboat is fully equipped at the time it is leased. Most of the equipment is provided by the owners, but some is added by Miller. The owner-provided equipment includes what is fixed on the boat, such as radios, compasses, depth indicators and other instrumentation, stoves, and refrigerators. Other owner-provided equipment is not installed as part of the boat. Such equipment includes sails, lines, anchors, dinghies, life preservers, and, in the cabin, dishes, silverware, cooking utensils, bedding, and the like. Miller provides consumable equipment, which could also be considered supplies, such as charts, navigation books, tide and current tables, soap, dish towels, toilet paper, and similar items. An important part of Miller's responsibilities is keeping track of the equipment on the boat. Much of it is expensive, and some of it, particularly what is not attached to the boat, can easily be lost or stolen. Customers are responsible for all equipment during the period of their charter. Miller likes to keep accurate records of its customers and the charters, not only for marketing but also for recording which customers have gone on which trips. Some itineraries and weather conditions are more dangerous than others, and so Miller also likes to know which customers have what experience. Most of Miller's business is bare-boat chartering, which means that no skipper or other crew is provided. In some cases, however, customers request the services of a skipper or other crew member, and so Miller hires such personnel on a part-time basis. Sailboats often need maintenance. Miller is required by its contracts with the boat owners to keep accurate records of all maintenance activities and costs, including normal activities such as cleaning or engine-oil changes, and unscheduled repairs. In some cases, repairs are necessary during a charter. A boat engine, for example, might fail while the boat is far away from Miller's facility. In this case, the customers radio the Miller dispatcher, who determines the best facility nearby to make the repair and requests proper personnel to the disabled boat. To make these decisions, the dispatchers need information about repair facilities as well as past histories of repair quality and costs.

1..conduct the conceptual database design...

Answer 1

E-R Diagram-

• This Er model has 11 main entities-

1. customers
2. owners
3. charters
4. equipment
5. sailboats
6. maintenance
7. personnel
8. trips
9. itineraries
10. service
11. weather

• This Er model has has been converted into 3NF
• Here each entity and its attributes are in tabular form
• Data types of each attribute has been mentioned with it
• The primary key as PK and foriegn key as FK has been mentioned there.