Data base 1

Client
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

Branch
ID	Branch No	Street	City	Post Code
2	B007	16 Argyll St.	Aberdeen	AB2 3SU
4	B004	32 Monse Rd.	Bristol	BS99 1NZ
3	B003	163 Main St.	Glasgow	G11 9QX
5	B002	56 Clover Dr.	London	NW10 6EV
1	B005	22 Deer Rd.	London	SW1 4EH

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

Property for 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

Registration
ID	Client No	Branch No	Staff No	Date_Journed
1	CR76	B005	SG41	02/01/2001
2	CR56	B003	SG37	11/04/2000
3	CR74	B003	SG37	16/11/1999
4	CR62	B007	SA9	07/03/2000

Staff
ID	Staff No	First Name	Last Name	Position	Sex	DOB	Salary	Branch No
1	SL21	John	White	Manager	M	01/10/1945	30000	B005
2	SG37	Ann	Black	Assistant	F	10/11/1960	120000	B003
3	SG14	David	Foro	Supervisor	M	29/03/1958	180000	B003
4	SA9	Mary	Nowe	Assistant	F	19/02/1970	9000	B007
5	SG5	Susan	Brand	Manager	F	03/06/1940	84000	B003
6	SL41	Vike	Lee	Assistant	F	13/06/1965	9000	B005

Viewing
ID	Client No	Property No	View_date	Comment
1	CR56	PA14	26/03/2001	Too Small
2	CR76	PG4	20/04/2001	Too Remote
3	CR56	PG4	26/05/2001	-
4	CR62	PA14	14/05/2001	No Dinning Room
5	CR56	PG36	28/04/2001	-