Database Reference
In-Depth Information
In the Marina table shown in Figure 1-20, Alexamara stores information about its two marinas. A marina
number uniquely identifies each marina. The table also includes the marina name, address, city, state, and
zip code.
23
FIGURE 1-20
Sample marina data for Alexamara Marina Group
Alexamara stores information about the boat owners to whom it rents slips in the Owner table shown in
Figure 1-21. An owner number that consists of two uppercase letters followed by a two-digit number uniquely
identifies each owner. For each owner, the table also includes the last name, first name, address, city, state,
and zip code.
Owner
OwnerNum
LastName
FirstName
Address
City
State
Zip
AD57
Adney
Bruce and Jean
208 Citrus
Bowton
FL
31313
AN75
Anderson
Bill
18 Wilcox
Glander Bay
FL
31044
BL72
Blake
Mary
2672 Commodore
Bowton
FL
31313
EL25
Elend
Sandy and Bill
462 Riverside
Rivard
FL
31062
FE82
Feenstra
Daniel
7822 Coventry
Kaleva
FL
32521
JU92
Juarez
Maria
8922 Oak
Rivard
FL
31062
KE22
Kelly
Alyssa
5271 Waters
Bowton
FL
31313
NO27
Norton
Peter
2811 Lakewood
Lewiston
FL
32765
SM72
Smeltz
Becky and Dave
922 Garland
Glander Bay
FL
31044
TR72
Trent
Ashton
922 Crest
Bay Shores
FL
30992
FIGURE 1-21
Sample owner data for Alexamara Marina Group
Each marina contains slips that are identified by slip numbers. Marina 1 (Alexamara East) has two sec-
tions named A and B. Slips are numbered within each section. Thus, slip numbers at marina 1 consist of
the letter A or B followed by a number (for example, A3 or B2). At marina 2 (Alexamara Central), a number
(1, 2, 3) identifies each slip.
Information about the slips in the marinas is contained in the MarinaSlip table shown in Figure 1-22. The
table contains the slip ID, marina number, slip number, length of the slip (in feet), annual rental fee, name of
the boat currently occupying the slip, type of boat, and boat owner
'
s number.
Search WWH ::




Custom Search