Insert the following records AFTER you have inserted the records given in the text.  

INSERT INTO branch
VALUES('C005','22 DEER RD','LONDON','SW1 4EH');
INSERT INTO branch
VALUES('B007','16 ARGYLL ST','ABERDEEN','');
INSERT INTO BRANCH
VALUES('B013',,'GLASGOW','G11 9QX');
INSERT INTO BRANCH
VALUES('B014','32 MANSE RD',' ','BS99 1NZ');
INSERT INTO BRANCH
VALUES('B0120','56 CLOVER DR','LONDON','NW10 6EU');
INSERT INTO STAFF
VALUES('S21','JOHN',' ' ,'MANAGER','M','1-OCT-45',30000,'B015');
INSERT INTO STAFF
VALUES('SG67','ANN','BEECH','ASSISTANT','X','10-NOV-60',12000,'B007');
INSERT INTO STAFF
VALUES('SG94','DAVID','FORD','SUPERVISOR','M','24-MAR-58',18,'B007');
INSERT INTO STAFF
VALUES('SX9','MARY','HOWE','ASSISTANT','F','19-FEB-70',9000,'B007');
INSERT INTO STAFF
VALUES('SG5','' ,'' ,'MANAGER','F','3-JUN-40',24000,'B007');
INSERT INTO STAFF
VALUES('SL91','JULIE','LEE','ASSISTANT',NULL ,'13-JUN-65',9000,'B007');
INSERT INTO PROPERTYFORRENT
VALUES('PV94','16 HOLHEAD','ABERDEEN','AB7 5SU','HOUSE',6,650,'CO46','SA9','B007');
INSERT INTO PROPERTYFORRENT
VALUES('PL54','6 ARGYLL ST','LONDON','NW2','DUMP',4,400,'CO87','SL41','B005');
INSERT INTO PROPERTYFORRENT
VALUES('PG4','6 LAWRENCE ST','GLASGOW','G11 9QX','FLAT',3,350,'CO40','','');
INSERT INTO PROPERTYFORRENT
VALUES('PG56','2 MANOR RD','GLASGOW','G12','HOUSE',5,600,'CO87','SG37',);
INSERT INTO PROPERTYFORRENT
VALUES('PG516','' ,'' ,'','FLAT',4, ,'CO93','SG14','B003');
INSERT INTO CLIENT
VALUES('CR16','JOHN','KKAY','0207-774-5632','ROOM',425);
INSERT INTO CLIENT
VALUES('CO16','ALINE','STEWART','0141-848-1825','FLAT','350');
INSERT INTO CLIENT
VALUES('CR94','MIKE','RITCHIE','392178','HOUSE',750); 
INSERT INTO CLIENT
VALUES('CR82','MARY','TREGEAR','01224-196720','FLAT',); 
INSERT INTO PRIVATEOWNER
VALUES('46','JOE','KEOGH','2 FERGUS DR, ABERDEEN AB2 7SX','01224-861212');
INSERT INTO PRIVATEOWNER
VALUES(' ','CAROL','FARREL','6 ACHRAY ST, GLASGOW G32 9DX','0141-357-7419');
INSERT INTO PRIVATEOWNER
VALUES('CO90','TINA','MURPHY','63 WELLS ST, GLASGOW G42','0141-943-1728');
INSERT INTO PRIVATEOWNER
VALUES('CO23','TONY','SHAW','12 PARK PL, GLASGOW G4 0QR',);
INSERT INTO VIEWING
VALUES('CR26','PA14','24-MAY-01','TOO SMALL');
INSERT INTO VIEWING
VALUES('CR76','PG56','20-APR-01','TOO REMOTE');
INSERT INTO VIEWING
VALUES('CR56','PG14','26-MAY-01','');
INSERT INTO VIEWING
VALUES('CR82','PA14','14-MAY-01','NO DINING ROOM');
INSERT INTO VIEWING
VALUES('CR82','PA14','','NO DINING ROOM');
INSERT INTO VIEWING
VALUES('CR83','PA14','14-MAY-01','NO DINING ROOM');
INSERT INTO VIEWING
VALUES('CR56','PG36', ,'');
INSERT INTO REGISTRATION
VALUES('CR76','B005','',);
INSERT INTO REGISTRATION
VALUES('CR156','B003','SG37','11-APR-00');
INSERT INTO REGISTRATION
VALUES('CR74','B003','SX37','16-NOV-05');
INSERT INTO REGISTRATION
VALUES('CR62','B007',,'7-MAR-00');