Bookings
|
Booking_no |
Date_reserved |
Reserved_by |
Date_rent_start |
Renta_period |
Registration |
Model_name |
Miles_out |
Miles_in |
Amount_due |
Paid |
Cust_no |
|
502 |
11/29/90 |
JANE B |
12/20/90 |
15 |
G123RMR |
BMW 750 |
500 |
3045 |
$4,002.00 |
N |
|
|
118 |
1/23/91 |
JANE B |
1/23/91 |
4 |
H626RPG |
JAG XJS |
800 |
1692 |
$1,123.80 |
N |
2338 |
|
265 |
4/9/91 |
ERIC |
5/4/91 |
16 |
E246WFC |
RR SSPIR |
35262 |
35818 |
$1,366.60 |
N |
2338 |
|
503 |
4/12/91 |
ERIC |
4/26/91 |
5 |
H203PBR |
LAMB COU |
3521 |
3862 |
$593.75 |
Y |
8979 |
|
504 |
4/12/91 |
JANE H |
4/12/91 |
1 |
G551JBA |
JAG XJ6 |
9527 |
9811 |
$476.95 |
N |
2804 |
|
586 |
4/13/91 |
JANE B |
4/26/91 |
21 |
F111ENT |
P911 TC |
25967 |
26818 |
$2,090.80 |
N |
2804 |
|
2122 |
9/21/91 |
|
9/21/91 |
1 |
G994PBR |
FERR TR |
|
|
|
|
1086 |
|
599 |
12/21/91 |
|
1/1/92 |
3 |
H311MHG |
MERC 560 |
|
|
|
|
2029 |
|
2123 |
9/8/91 |
|
9/19/91 |
5 |
H935CSA |
FERR TR |
23774 |
25865 |
$501.80 |
N |
667 |
|
2124 |
9/18/91 |
|
9/19/91 |
5 |
G123RMR |
BMW 750 |
61554 |
72334 |
$1,023.00 |
N |
701 |
|
2125 |
10/2/91 |
|
10/2/91 |
2 |
G551JBA |
JAG XJ6 |
1098 |
882 |
$100.00 |
Y |
734 |
|
2126 |
10/2/91 |
|
10/2/91 |
10 |
H266MHU |
ASTON V8 |
5583 |
6254 |
$873.60 |
N |
668 |
|
2127 |
10/1/91 |
|
10/1/91 |
1 |
J644TNR |
MERC 560 |
8891 |
9024 |
$106.00 |
N |
8981 |
|
2128 |
4/13/91 |
|
4/14/91 |
10 |
H235BMA |
LAMB COU |
44512 |
45277 |
$512.00 |
N |
668 |
Cars
|
Registration |
Model_name |
Car_group_name |
Data_bought |
Cost |
Miles_to_date |
Miles_last_service |
Status |
|
H286 MHU |
P911 TC |
A2 |
5/13/85 |
$63,290.00 |
18000 |
15451 |
A |
|
H266MHU |
ASTON V8 |
A1 |
4/1/91 |
$63,000.00 |
2597 |
1000 |
A |
|
G899VDU |
BMW 635 |
B2 |
10/23/89 |
$45,500.30 |
18675 |
12667 |
A |
|
G123RMR |
BMW 750 |
B3 |
11/16/89 |
$56,829.00 |
42400 |
25366 |
A |
|
E246WFC |
RR SSPIR |
B4 |
1/6/88 |
$84,500.00 |
52861 |
48253 |
H |
|
G994PBR |
FERR TR |
A4 |
3/31/90 |
$102,450.00 |
10662 |
6004 |
A |
|
H626RPG |
JAG XJS |
A2 |
9/26/90 |
$32,650.30 |
14533 |
12769 |
A |
|
G551JBA |
JAG XJ6 |
A3 |
9/2/89 |
$45,500.00 |
13788 |
11950 |
A |
|
H203PBR |
LAMB COU |
A4 |
11/10/90 |
$130,250.00 |
7025 |
903 |
H |
|
F651DEK |
RR SSPIR |
B4 |
1/10/89 |
$92,500.00 |
29610 |
24460 |
A |
|
H311MHG |
MERC 560 |
B3 |
11/9/90 |
$60,800.00 |
12450 |
11832 |
A |
|
F111ENT |
P911 TC |
A3 |
9/3/88 |
$75,200.00 |
30286 |
24502 |
A |
|
G202XRP |
P944 T |
A3 |
2/14/89 |
$48,350.00 |
28604 |
23666 |
A |
|
J516BTA |
P944 T |
A3 |
9/2/91 |
$50,301.00 |
1502 |
|
A |
Customers
|
Cust_no |
Cust_name |
Address |
Town |
County |
Zip |
Contact |
|
2804 |
FOCUST MARKETING LTD |
555 SLOUGH ROAD |
WOKINGHAM |
BERKS |
RG23 1JK |
Jeanna Polly |
|
1086 |
ADT LTD |
BUMPERS IND EST |
CHIPPENHAM |
WILTS |
SN14 6LH |
James Nugent |
|
1553 |
EYRIE BOOKS LTD |
2 ST JOHNS AVE |
LONDON |
|
NW3 6TQ |
Alisdair Aird |
|
1452 |
STEVEN BEARE |
NETTLETON HOUSE |
CASTLE COMBE |
WILTSHIRE |
SN13 7NJ |
Steven Beare |
|
2029 |
SQL STARS LTD |
10 PENN LEA ROAD |
BATH |
AVON |
BA2 5MX |
Stan Blethyn |
|
667 |
G G WHITTAKER & CO |
WHEATLEY ROAD |
DONCASTER |
YORKSHIRE |
DN5 8AA |
Chris Whittaker |
|
701 |
MCGHIE ENTERPRISES |
CAMPFIELD ROAD |
BASINGSTOKE |
HANTS |
BK10 1BC |
Bob McGhie |
|
734 |
CARL PETROV LTD |
62 CADOGAN AVE |
BRISTOL |
AVON |
BS1 6TQ |
Jim Slattery |
|
668 |
THRINGS AND CO |
MOUNTEBANK HOUSE |
BASINGSTOKE |
HANTS |
RG22 1EL |
Brian Jones |
|
8981 |
CARDINAL CARDS LTD |
56 LOWER REGENT ST |
LONDON |
|
W1A 8TW |
Linden Boyne |
Models
|
Model_name |
Car_group_name |
Description |
Maint_int |
|
ASTON V8 |
A1 |
ASTON MARTIN V8 VANTAGE |
10000 |
|
BMW 635 |
B2 |
BMW 635 csi |
12000 |
|
BMW 750 |
B3 |
BMW 750 |
12000 |
|
FERR TR |
A4 |
Ferrari Testarossa |
10000 |
|
JAG XJS |
A2 |
Jaguar XJS V12 5.2l |
15000 |
|
JAG XJ6 |
A3 |
Jaguar XJ6 V12 Sovereign |
15000 |
|
JAG XJ6 |
A3 |
Jaguar XJ6 V12 Sovereign |
15000 |
|
LAMB COU |
A4 |
Lamborghini Countach |
6000 |
|
MERC 560 |
B3 |
Mercedes 560 SEL |
24000 |
|
P911 TC |
A3 |
Porsche 911 TC Cabriolet |
12000 |
|
P944 T |
A3 |
Porsche 944 Turbo |
12000 |
|
RR SSPIR |
B4 |
Rolls Royce Silver Spirit |
6000 |
CarGroups
|
Car_group_name |
Rate_per_mile |
Rate_per_day |
|
A1 |
110 |
$25.00 |
|
A2 |
115 |
$24.50 |
|
A3 |
155 |
$36.75 |
|
A4 |
125 |
$33.50 |
|
B1 |
110 |
$25.90 |
|
B2 |
125 |
$33.00 |
|
B3 |
135 |
$37.75 |
|
B4 |
135 |
$38.50 |