SAN JUAN SAILBOAT CHARTERS San Jaan Sailboat Charters (SJSBC) is an apency that lemes (charters) sailbouts. SJSBC. does not own the boats. Instead, SJSBC leases boats on behalf of bout owners who wane to earn income from their bouts when they are not wine them, and SJSBC charpen the owners a fee for this service. SJSBC specializes in beuts that can be uned for multidny er weekly charten. The smallest sailboat available is 28 fert in lenghth and the largest is 51 feet in length. Each sailbout is fully equipped at the time it is leased. Mont of the equipenent is provided at the time of the charter. Most of the equipment is provided by the owners, tuat wame is provided by SJSBC. The owner-provided equipment includes equigtaent that is artached to the boat, sudh as ratios, conpases, depth indicatoes and other inatrumentation, stoves. and refrigeratoes. Onher ewnenptovided equipment, such as sails, lines, anchoes, dinghies, life preservers, and equipment in the cabin (diahes, sitverware, cooking utenik, bedling. and so on), is not playsically attached to the boat. SISBC ptovides conuamable supplies. euch as charts, navigation books, tide and current tables, sosp, diah townl, tolet paper, and similar items. The consumable supplies afe treated as equipment by SJSBC for tracking and accounting purposes. Keeping track of equipment is an important part of SJSBC's reoponikalise. Meach of the equipmeat is expensive, and thone items not physically attached to the bout can be eandy dumaged, loat, of stoien. SJSEC holds the custoner tesponsble for all the boar's eyuipenent during the period of the charter. SJSBC likes to keep accurate records of its cwstomers and charten, and castumes are required to keep a log during each charter. Some itisetaries and veather conditions are mere danperous than oahers, and the data from these los prowide information abont the custoener experience. This information is useful for marketing praposes as well as for cvaluating a customer's ability to handle a purticular bost and itincrary. Sailbouts need maintenance. Note that two definitions of beet are (1) "beak oest anoth. er thousand" and (2) "a hele in the water into which one poun money. SJSBC as required by its coetracts with the bout owners so keep accurate recoedh of all maintenance actinitio and contk. A data model of a proposed database to support an information system for SJSBC: is shown in Figure 5-30. Note that because the OWNER entity allows for ownen to be companies as well as individuals. SJSBC can be iacluded as an equipment ewner (note that the cardinalities in the diagrams allow SJSBC to own equipenent while nof owning any boats). Also note that this model relates EQUTPMENT to CHLRTER rather than BOAT even when the equipment is physically attached to the bout. This is only one posvible way to handle EQUIPMENT, bet it is satiafactory to the managen of SJSBC. A. Convert this data model to a database design. Specify tables, primary leys, and foreign keys. Using Figure 5.26 and Figure 5.28 as guides, specify colum peogertion. B. Describe how you have represented weak entities, if any exist. C. Describe bow you have reptesented supertype and wubtype entitics, if any exist. D. Create a visual representation of your database design as an IE Crow's Foot E-R dir. gram similar to the one in Figure 5-27. E. Document referential integrity conutraint enforcenert, ucing Figure 5.29 at a gude. SAN JUAN SAILBOAT CHARTERS San Jaan Sailboat Charters (SJSBC) is an apency that lemes (charters) sailbouts. SJSBC. does not own the boats. Instead, SJSBC leases boats on behalf of bout owners who wane to earn income from their bouts when they are not wine them, and SJSBC charpen the owners a fee for this service. SJSBC specializes in beuts that can be uned for multidny er weekly charten. The smallest sailboat available is 28 fert in lenghth and the largest is 51 feet in length. Each sailbout is fully equipped at the time it is leased. Mont of the equipenent is provided at the time of the charter. Most of the equipment is provided by the owners, tuat wame is provided by SJSBC. The owner-provided equipment includes equigtaent that is artached to the boat, sudh as ratios, conpases, depth indicatoes and other inatrumentation, stoves. and refrigeratoes. Onher ewnenptovided equipment, such as sails, lines, anchoes, dinghies, life preservers, and equipment in the cabin (diahes, sitverware, cooking utenik, bedling. and so on), is not playsically attached to the boat. SISBC ptovides conuamable supplies. euch as charts, navigation books, tide and current tables, sosp, diah townl, tolet paper, and similar items. The consumable supplies afe treated as equipment by SJSBC for tracking and accounting purposes. Keeping track of equipment is an important part of SJSBC's reoponikalise. Meach of the equipmeat is expensive, and thone items not physically attached to the bout can be eandy dumaged, loat, of stoien. SJSEC holds the custoner tesponsble for all the boar's eyuipenent during the period of the charter. SJSBC likes to keep accurate records of its cwstomers and charten, and castumes are required to keep a log during each charter. Some itisetaries and veather conditions are mere danperous than oahers, and the data from these los prowide information abont the custoener experience. This information is useful for marketing praposes as well as for cvaluating a customer's ability to handle a purticular bost and itincrary. Sailbouts need maintenance. Note that two definitions of beet are (1) "beak oest anoth. er thousand" and (2) "a hele in the water into which one poun money. SJSBC as required by its coetracts with the bout owners so keep accurate recoedh of all maintenance actinitio and contk. A data model of a proposed database to support an information system for SJSBC: is shown in Figure 5-30. Note that because the OWNER entity allows for ownen to be companies as well as individuals. SJSBC can be iacluded as an equipment ewner (note that the cardinalities in the diagrams allow SJSBC to own equipenent while nof owning any boats). Also note that this model relates EQUTPMENT to CHLRTER rather than BOAT even when the equipment is physically attached to the bout. This is only one posvible way to handle EQUIPMENT, bet it is satiafactory to the managen of SJSBC. A. Convert this data model to a database design. Specify tables, primary leys, and foreign keys. Using Figure 5.26 and Figure 5.28 as guides, specify colum peogertion. B. Describe how you have represented weak entities, if any exist. C. Describe bow you have reptesented supertype and wubtype entitics, if any exist. D. Create a visual representation of your database design as an IE Crow's Foot E-R dir. gram similar to the one in Figure 5-27. E. Document referential integrity conutraint enforcenert, ucing Figure 5.29 at a gude