ID
|
Branch No
|
Street
|
City
|
Post Code
|
1
|
B005
|
22 Deer Rd.
|
London
|
SW1 4EH
|
2
|
B007
|
16 Argyll St.
|
Aberdeen
|
AB2 3SU
|
3
|
B003
|
163 Main St.
|
Glasgow
|
G11 9QX
|
4
|
B004
|
32 Monse Rd.
|
Bristol
|
BS99 1NZ
|
5
|
B002
|
56 Clover Dr.
|
London
|
NW10 6EV
|
client 2
ID
|
Private Owner
|
First Name
|
Last Name
|
Address
|
Telephone No
|
1
|
CO46
|
Joe
|
Keogh
|
2 Fergus Dr. Aberdeen AB2 75X
|
1224861212
|
2
|
CO87
|
Carol
|
Farol
|
6 Archory St. Glasgow G32 9DX
|
1413577419
|
3
|
CO40
|
Tina
|
Murphy
|
63 Well St. Glasgow G42
|
1419431728
|
4
|
CO93
|
Tony
|
Shaw
|
12 Park PI Glasgow G4 0QR
|
1412257025
|
ID
|
Client No
|
First Name
|
Last Name
|
Telephone No
|
Pref Type
|
Max Rent
|
1
|
CR76
|
John
|
Kay
|
2077745632
|
Flat
|
435
|
2
|
CR56
|
Aline
|
Steward
|
1418481825
|
Flat
|
350
|
3
|
CR74
|
Mike
|
Ritchie
|
1475392178
|
Home
|
750
|
4
|
CR62
|
Mary
|
Treqear
|
1224196720
|
Flat
|
600
|
property of rent
ID
|
Property No
|
Street
|
City
|
Post Code
|
Type
|
Rooms
|
Rent
|
Owner No
|
Staff No
|
Branch No
|
1
|
PA14
|
16 Holhead
|
Aberdeen
|
A37530
|
Home
|
6
|
650
|
CO46
|
SA9
|
B007
|
3
|
PG4
|
6 Lawrence St.
|
Glasgow
|
G11 9QX
|
Flat
|
3
|
350
|
CO40
|
-
|
B003
|
5
|
PG21
|
18 Dale Rd.
|
Glasgow
|
G12
|
Home
|
5
|
600
|
CO87
|
SG37
|
B003
|
6
|
PG16
|
5 Novar Dr.
|
Glasgow
|
G12 9AX
|
Flat
|
1
|
450
|
C093
|
SG14
|
B003
|
4
|
PG36
|
2 Monor Rd.
|
Glasgow
|
G32 4QX
|
Flat
|
3
|
375
|
CO93
|
SG37
|
B003
|
2
|
PL94
|
6 Argyll
|
London
|
NW2
|
Flat
|
4
|
400
|
CO87
|
SL41
|
B005
|
ID
|
Staff No
|
First Name
|
Last Name
|
Position
|
Sex
|
DOB
|
Salary
|
Branch No
|
1
|
SL21
|
John
|
White
|
Manager
|
M
|
10/1/1945
|
30000
|
B005
|
2
|
SG37
|
Ann
|
Black
|
Assistant
|
F
|
11/10/1960
|
120000
|
B003
|
3
|
SG14
|
David
|
Foro
|
Supervisor
|
M
|
3/29/1958
|
180000
|
B003
|
4
|
SA9
|
Mary
|
Nowe
|
Assistant
|
F
|
2/19/1970
|
9000
|
B007
|
5
|
SG5
|
Susan
|
Brand
|
Manager
|
F
|
6/3/1940
|
84000
|
B003
|
6
|
SL41
|
Vike
|
Lee
|
Assistant
|
F
|
6/13/1965
|
9000
|
B005
|
ID
|
Client No
|
Branch No
|
Staff No
|
Date_Journed
|
1
|
CR76
|
B005
|
SG41
|
1/2/2001
|
2
|
CR56
|
B003
|
SG37
|
4/11/2000
|
3
|
CR74
|
B003
|
SG37
|
11/16/1999
|
4
|
CR62
|
B007
|
SA9
|
3/7/2000
|
ID
|
Client No
|
Property No
|
View_date
|
Comment
|
1
|
CR56
|
PA14
|
3/26/2001
|
Too Small
|
2
|
CR76
|
PG4
|
4/20/2001
|
Too Remote
|
3
|
CR56
|
PG4
|
5/26/2001
|
-
|
4
|
CR62
|
PA14
|
5/14/2001
|
No Dinning Room
|
5
|
CR56
|
PG36
|
4/28/2001
|
-
|
