Database Reference
In-Depth Information
MarinaSlip
24
SlipID MarinaNum SlipNum Length
RentalFee
BoatName
BoatType
OwnerNum
1
1
A1
40
$3,800.00
Anderson II
Sprite 4000
AN75
2
1
A2
40
$3,800.00
Our Toy
Ray 4025
EL25
3
1
A3
40
$3,600.00
Escape
Sprite 4000
KE22
4
1
B1
30
$2,400.00
Gypsy
Dolphin 28
JU92
5
1
B2
30
$2,600.00
Anderson III
Sprite 3000
AN75
6
2
1
25
$1,800.00
Bravo
Dolphin 25
AD57
7
2
2
25
$1,800.00
Chinook
Dolphin 22
FE82
8
2
3
25
$2,000.00
Listy
Dolphin 25
SM72
9
2
4
30
$2,500.00
Mermaid
Dolphin 28
BL72
10
2
5
40
$4,200.00
Axxon II
Dolphin 40
NO27
11
2
6
40
$4,200.00
Karvel
Ray 4025
TR72
FIGURE 1-22
Sample data about marina slips for Alexamara Marina Group
Q&A
Question: To check your understanding of the relationship between owners and marina slips, answer the
following questions: Who owns Axxon II? What are the names of the boats owned by Bill Anderson?
Answer: Peter Norton owns Axxon II. In the row in the MarinaSlip table for Axxon II (see Figure 1-22), find
owner number NO27. Examining the Owner table (see Figure 1-21), you see that NO27 is the code assigned
to Peter Norton.
Bill Anderson owns Anderson II and Anderson III. To find the boats owned by Bill Anderson, find his
owner number (AN75) in the Owner table. Next, find all rows in the MarinaSlip table for which the owner
number is AN75.
Alexamara provides boat maintenance service at its two marinas. The types of service provided are
stored in the ServiceCategory table shown in Figure 1-23. A category number uniquely identifies each service
that Alexamara performs. The table also contains a description of the category.
ServiceCategory
CategoryNum
CategoryDescription
1
Routine engine maintenance
2
Engine repair
3
Air conditioning
4
Electrical systems
5
Fiberglass repair
6
Canvas installation
7
Canvas repair
8
Electronic systems (radar, GPS, autopilots, etc.)
FIGURE 1-23
Sample data about service categories for Alexamara Marina Group
Information about the services requested by owners is stored in the ServiceRequest table shown in
Figure 1-24. Each row in the table contains a service ID that identifies each service request. The slip ID
identifies the location (marina number and slip number) of the boat to be serviced. For example, the slip ID
on the second row is 5. As indicated in the MarinaSlip table, the slip ID 5 identifies the boat in marina 1 and
slip number B2. The ServiceRequest table also contains the category number of the service to be performed,
