DreamHome 数据

insert into Branch values('B005','22 Deer Rd','London','SW1 4EH');
insert into Branch values('B007','16 Argylly Rd','Aberdeen','AB2 3SU');
insert into Branch values('B003', '163 Main St', 'Glasgow', 'G11 9QX');
insert into Branch values('B004', '32 Manse Rd', 'Bristol', 'BS99 1NZ');
insert into Branch values('B002', '56 Clover St', 'London', 'NW10 6EU');

insert into Staff values('SL21','John','White','Manager','M','1945-10-1',30000,'B005');
insert into Staff values('SG37', 'Ann', 'Beech', 'Assistant', 'F', '1960-11-10', 12000, 'B003');
insert into Staff values('SG14', 'David', 'Ford', 'Supervisor', 'M', '1958-03-24', 18000, 'B003');
insert into Staff values('SA9', 'Mary', 'Howe', 'Assistant', 'F', '1970-02-19', 9000, 'B007');
insert into Staff values('SG5', 'Susan', 'Brand', 'Manager', 'F', '1940-06-03', 24000, 'B003');
insert into Staff values('SL41', 'Julie', 'Lee', 'Assistant', 'F', '1965-06-13', 9000, 'B005');

insert into PropertyForRent values ('PA14','16 Holhead','Aberden','AB7 5SU','House',6,650,'CO46','SA9','B007');
insert into PropertyForRent values('PL94', '6 Argyll St', 'London', 'NW2', 'Flat', 4, 400, 'CO87', 'SL41', 'B005');
insert into PropertyForRent values('PG4', '6 Lawrence St', 'Glasgow', 'G11 9QX', 'Flat', 3, 350, 'CO40', NULL, 'B003');
insert into PropertyForRent values ('PG36', '2 Manor Rd', 'Glasgow', 'G32 4QX', 'Flat', 3, 375, 'CO93', 'SG37', 'B003');
insert into PropertyForRent values('PG21', '18 Dale Rd', 'Glasgow', 'G12', 'House', 5, 600, 'CO87', 'SG37', 'B003');
insert into PropertyForRent values('PG16', '5 Novar Dr', 'Glasgow', 'G12 9AX', 'Flat', 4, 450, 'CO93', 'SG14', 'B003');

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

insert into Client values ('CR76','John','Kay','0207-774-5632','Flat',425);
insert into Client values ('CR56', 'Aline', 'Stewart', '0141-848-1826', 'Flat', 350);
insert into Client values('CR74', 'Mike', 'Ritchie', '01475-392178', 'House', 750);
insert into Client values('CR62', 'Mary', 'Tregear', '01224-196720', 'Flat', 600);

insert into Viewing values('CR56','PA14','2004-05-24','too small');
insert into Viewing values('CR76', 'PG4', '2004-04-20', 'too remote');
insert into Viewing values('CR56', 'PG4', '2004-05-26', NULL);
insert into Viewing values('CR62', 'PA14', '2004-05-14', 'no dining room');
insert into Viewing values('CR56', 'PG36', '2004-04-28', NULL);

insert into Registration values('CR76','B005','Sl41','2004-1-2');
insert into Registration values('CR56', 'B003', 'SG37', '2003-04-11');
insert into Registration values('CR74', 'B003', 'SG37', '2002-11-16');
insert into Registration values('CR62', 'B007', 'SA9', '2003-03-07');