Dreamhouse Database

Branch

Branch NO	Street	City	Postcode
B002	50 Clover Dr.	London	NW10 6EU
B003	163 Main st.	Glosgow	G11 9 QX
B004	31 Mouse Rd.	Bristol	BS99 IN2
B005	22 Deer Rd.	London	SWI 4EH
B007	16 Argyll st.	Aberdeen	AB 2 3 SU

Client

Client NO	F Name	L Name	Tel NO	Pref type	Max Rent
CR76	John	Kay	0207-774-5632	Flat	425
CR56	Aline	Stewart	0141-848-1825	Flat	350
CR74	Mike	Ritchie	0147-539-2178	House	750
CR62	Marry	Tregear	0122-419-6720	Flat	600

Private Owner

Private Owner	F Name	L Name	Address	tel NO
C040	Tina	Murphy	53 Well st. Glasgow 642	0141-943-1728
C046	Joe	Keogh	2 Fergus Dr. Aberdieen AB 275X	0122-486-1212
C093	Tony	Shaw	12 Park Pl. Glasgow 640 QR	0141-225-7025
Co87	Carol	Farrel	6 Achray st. Glasgow 6329 DX	0141-357-7419

Property for Rent

Property NO	Street	City	Post Code	Type	Rooms	Rent	Owner NO	Staff NO	Branch No
P363	2 Monur Rd.	Glasgow	6324QX	Flat	3	375	C093	S637	B003
P616	5 Novar Dr.	Glasgow	6129AX	Flat	4	450	C093	S614	B003
P621	18 Dale Rd.	Glasgow	612	House	5	600	C087	S637	B003
P64	6 Lowrence st.	Glasgow	6119QX	Flat	3	350	C040	-	B003
PA14	16 Holihead	Aberdeen	AB7550	House	6	650	C046	SA9	B007
PL94	6 Argxll st.	London	NW2	Flat	4	400	C087	S641	B005

Registration

Client NO	Branch NO	Staff NO	Date Joined
CR56	B003	S637	4/11/2000
CR62	B007	S49	3/7/2000
CR74	B003	S637	11/16/1999
CR76	B005	S641	1/2/2001

Staff

Staff NO	F Name	L Name	Position	Sex	DOB	Salary	Branch NO
S614	David	Ford	Supervisor	M	3/24/1958	18000	B003
S637	Ann	Beech	Assistant	F	11/10/1960	12000	B003
S641	Luke	Lee	Assistant	F	6/13/1965	9000	B005
S65	Susan	Brand	Manager	F	6/3/1940	24000	B003
SA9	Mary	Howe	Assistant	F	2/19/1970	9000	B007
SL21	John	White	Manager	M	10/1/1945	30000	B005

Viewing

Client NO	Property NO	View Date	Comment
CR56	PA14	3/24/2001	too small
CR76	P64	4/20/2001	too remote
CR56	P64	5/26/2001	-
CR62	PA14	5/14/2001	no dining room
CR56	P636	4/28/2001