Unit $6$ Assignment: Convert Data Model to a Database Design

Due Monday by $11$:$59$pm Points $45$ Submitting a file upload File Types docx, doc, and pdf Available until Apr $26$ at $11$:$59$pm

Assignment Instructions

San Juan Sailboat Charters $($SJSBC$)$ is an agency that leases $($charters$)$ 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 them, and SJSBC charges the owners a fee for this service. SJSBC specializes in boats that can be used for multiday or weekly charters. The smallest sailboat available is $28$ feet in length, and the largest is $51$ feet in length.

Each sailboat is fully equipped at the time it is leased. Most of the equipment is provided at the time of the charter. Most of the equipment is provided by the owners, but some by SJSBC$.$ The owner$-$provided equipment includes equipment attached to the boat, such as radios, compasses, depth indicators, other instrumentation, stoves, and refrigerators. Other owner$-$provided equipment, such as sails, lines, anchors, dinghies, life preservers, and equipment in the cabin $($dishes$,$ silverware, cooking utensils, bedding, and so on$),$ is not physically attached to the boat. SJSBC provides consumable supplies such as charts, navigation books, tide, current tables, soap, dish towels, toilet paper, and other items. The consumable supplies are treated as equipment by SJSBC for tracking and accounting purposes.

Keeping track of equipment is an important part of SJSBC$\text{'}$s responsibilities. Much of the equipment is expensive, and those items not physically attached to the boat can be easily damaged, lost, or stolen. SJSBC holds the customers responsible for all of the boat's equipment during the charter period.

SJSBC likes to keep accurate records of its customers and charters, and customers must keep a log during each charter. Some itineraries and weather conditions are more dangerous than others, and the data from these logs provide information about the customer experience. This information is useful for marketing purposes and evaluating a customer's ability to handle a particular boat and itinerary.

Sailboats need maintenance. Note that two definitions of a boat are: $(1)$ "break out another thousand" and $(2)$ "a hole in the water into which one pours money." SJSBC is required by its contracts with the boat owners to keep accurate records of all maintenance activities and costs.

$9$ A data model of a proposed database to support an information system for SJSBC is shown in Figure $6-45.$ Note that because the OWNER entity allows for owners to be companies as well as individuals, SJSBC can be included as an equipment owner $($note that the cardinalities in the diagram allow SJSBC to own equipment while not owning any boats$).$ Also, note that this model relates EQUIPMENT to CHARTER rather than BOAT even when the equipment is physically attached to the boat. This is only one possible way to handle EQUIPMENT, but it is satisfactory to the managers of SJSBC$.$

SCHEDULED$\_$MAINTENANCE

FIGURE $6-45$

Data Model for San Juan

Sailboat Charters

Question:

Question:

Convert this data model to a database design. Specify tables, primary keys, foreign keys, and column properties. The database design should be represented using a Crow's Foot E$-$R diagram. $q,$

Guidelines

Include the following:

Include your last name in the filename $($example: Unit$-6$ AS Smith.$)$

The file must be submitted in either Word or PDF format.