DreamHome.relax

group:DreamHome

Branch = {
	bno:string, street:string, area:string, city:string, pcode:string, tel_no:string, fax_no:string

'B5','22 Deer Rd','Sidcup','London','SW1 4EH','0171-886-1212','0171-886-1214'
'B7','16 Argyll St','Dyce','Aberdeen','AB2 3SU','01224-67125','01224-67111'
'B3','163 Main St ','Patrick','Glasgow','G11 9QX','0141-339-2178','0141-339-4439'
'B4','32 Manse Rd','Leigh','Bristol','BS99 1NZ','0117-916-1170','0117-776-1114'
'B2','56 Clover Dr','','London','NW10 6EU','0181-963-1030','0181-453-7992'
}

Staff = {
	sno:string, fname:string, lname:string, address:string, tel_no:string, position:string, sex:string, dob:string, salary:number, nin:string, bno:string

'SL21','John','White','19 Taylor St, Cranford, London','0171-884-5112','Manager','M','1-Oct-45',300000,'WK442011B','B5'
'SG37','Ann','Beech','81 George St, Glasgow PA1 2JR','0141-848-3345','Snr Asst','F','10-Nov-60',12000 ,'WL432514C','B3'
'SG14','David','Ford','63 Ashby St, Patrick Glasgow G11','0141-339-2177','Deputy','M','24-Mar-58',18000,'WL220658D','B3'
'SA9','Mary','Howe','2 Elm Pl, Aberdeen AB2 3SU','','Assistant','F','19-Feb-70',9000,'WM532187D','B7'
'SG5','Susan','Brand','5 Gt Western Rd, Glasgow G12','0141-334-2001','Manager','F','3-Jun-40',24000,'WK588932E','B3'
'SL41','Julie','Lee','28 Malvern St, Kilburn NW2','0181-554-3541','Assistant','F','13-Jun-65',9000,'WA290573K','B5'

}

Property_For_Rent = {
	pno:string, street:string, area:string, city:string, pcode:string, type:string, rooms:number, rent:number, ono:string, sno:string, bno:string

'PA14','16 Holhead','Dee','Aberdeen','AB7 5SU','House','6','650','CO46','SA9','B7'
'PL94','6 Argyll St','Kilburn','London','NW2','Flat','4','400','CO87','SL41','B5'
'PG4','6 Lawrence St','Patrick','Glasgow','G11 9QX','Flat','3','350','CO40','SG14','B3'
'PG36','2 Manor Rd','','Glasgow','G32 4QX','Flat','3','375','CO93','SG37','B3'
'PG21','18 Dale Rd','Hyndland','Glasgow','G12','House','5','600','CO87','SG37','B3'
'PG16','5 Novar Dr','Hyndland','Glasgow','G12 9AX','Flat','4','450','CO93','SG14','B3'

}

Renter = {
	rno:string, fname:string, lname:string, address:string, tel_no:string, pref_type:string, max_rent:number

'CR76','John','Kay','56 High St, Putney, London SW1 4EH','0171-774-5632','Flat',425
'CR56','Aline','Steward','64 Fern Dr, Pollock, Glasgow G42 0Bl','0141-848-1825','Flat',350
'CR74','Mike','Ritchie','18 Tain St, Gourock PA1G 1YQ','01475-392178','House',750
'CR62','Mary','Tregear','5 Tarbot Rd,Kildary, Aberdeen AB9 3ST','01224-196720','Flat',600

}

Owner = {
	ono:string, fname:string, lname:string, address:string, tel_no:string

'CO46','Joe','Keogh','2 Fergus Dr, Banchory, Aberdeen AB2 7SX','01224-861212'
'CO87','Carol','Farrel','6 Achray St, Glasgow G32 9DX','0141-357-7419'
'CO40','Tina','Murphy','63 Well St, Shawlands, Glasgow G42','0141-943-1728'
'CO93','Tony','Shaw','12 Park Pl, Hillhead, Glasgow G4 0QR','0141-225-7025'

}


Viewing = {
 rno:string, pno:string, date:string, comment:string

'CR56','PA14','24-May-95','too small'
'CR76','PG4','20-Apr-95','too remote'
'CR56','PG4','26-May-95',''
'CR62','PA14','14-May-95','no dining room'
'CR56','PG36','28-Apr-95',''

}