San Juan Sailboat Charters (SJSBC) is an agency that leases (charters) sailboats
ID: 3850548 • Letter: S
Question
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 the boats themselves, 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. The majority of the equipment is provided by the owners, but some is provided by SJSBC. Some of the owner-provided equipment is attached to the boat, such as radios, compasses, depth indicators and other instrumentation, stoves, and refrigerators. Other owner-provided equipment is not physically attached to the boat, such as sails, lines, anchors, dinghies, life preservers, and equipment in the cabin (dishes, silverware, cooking utensils, bedding, and so on). SJSBC provides consumable supplies such as charts, navigation books, tide and current tables, soap, dish towels, toilet paper, and similar 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’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 period of their charter. SJSBC likes to keep accurate records of its customers and charters, and customers are required to keep a log during each charter. Some itineraries and weather conditions are more dangerous than others, and the data from these logs provides information about the customer experience. This information is useful for marketing purposes, as well as for evaluating a customer’s ability to handle a particular boat and itinerary. Sailboats need maintenance (two definitions of 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. A.Create a sample list of owners and boats. Your list will be similar in structure to that in Figure 1-30, but it will concern owners and boats rather than owners and pets. Your list should include, at a minimum, owner name, phone, and billing address, as well as boat name, make, model, and length. B.Describe modification problems that are likely to occur if SJSBC attempts to maintain the list in a spreadsheet. C.Split the list into tables such that each has only one theme. Create appropriate ID columns. Use a linking column to represent the relationship between a boat and an owner. Demonstrate that the modification problems you identified in part B have been eliminated. D.Create a sample list of owners, boats, and charters. Your list will be similar to that in Figure 1-31. Your list should include the data items from part A as well as the charter date, charter customer, and the amount charged for each charter. E.Illustrate modification problems that are likely to occur if SJSBC attempts to maintain the list from part D in a spreadsheet. F.Split the list from part D into tables such that each has only one theme. Create appropriate ID columns. Use linking columns to represent relationships. Demonstrate that the modification problems you identified in part E have been eliminated.
Explanation / Answer
A.
owner
ow_id
ow_name
ow_ph
ow_add
ow1
rahul
9236598469
a-zone
ow2
sachin
7589654123
b-zone
ow3
pinky
4589632156
a-zone
ow4
tara
6859421369
b-zone
boat
bo_id
bo_name
bo_make
bo_model
bo_leng
bo1
piku
12/1/2014
bo1234
28
bo2
tiku
11/2/2015
bo1235
51
bo3
maku
10/4/2010
bo1236
36
bo4
taku
24/8/2007
bo1237
48
bo5
laku
12/1/2014
bo1238
51
bo6
maku
11/2/2015
bo1239
28
bo7
kuku
10/4/2010
bo1240
46
bo8
guku
24/8/2008
bo1241
38
B. MODIFICATION PROBLEM
C.
relation table
ow_id
bo_id
modify
cost
ow1
bo1234
color
200
ow1
bo1235
parts
100
ow2
bo1236
color
500
ow2
bo1237
parts
300
ow3
bo1238
color
400
ow3
bo1239
parts
480
ow3
bo1240
color
540
ow4
bo1241
parts
600
D.
E.
MODIFY_TABLE
F.
summary table
owner
ow_id
ow_name
ow_ph
ow_add
ow1
rahul
9236598469
a-zone
ow2
sachin
7589654123
b-zone
ow3
pinky
4589632156
a-zone
ow4
tara
6859421369
b-zone
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.