Insert the following records AFTER you have created the constrained tables and inserted the 
records given in the text.  If a record will not insert make a note after the record stating
?	Whether it should be recorded
?	The changes necessary for insertion
If appropriate, make the changes and insert the record.

INSERT INTO branch
VALUES('B001','22 DEER RD','LONDON','SW2 4EH');
INSERT INTO branch
VALUES('B07','16 ARGYLL ST','ABERDEEN','AB2 3SU');
INSERT INTO BRANCH
VALUES('B013',NULL,'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 BRANCH
VALUES('C005','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','BENCH','ASSISTANT','X','10-NOV-60',12000,'B007');
INSERT INTO STAFF
VALUES('SG94','DAVID','FORD','SUPERVISOR','M','24-MAR-58',18000,'B007');
INSERT INTO STAFF
VALUES('SX9','MATT','HOWE','ASSISTANT','F','19-FEB-10',9000,'B007');
INSERT INTO STAFF
VALUES('SG9',' ',' ' ,'MANAGER','F','3-JUN-40',24000,'B007');
INSERT INTO STAFF
VALUES('SL91','JULIE','LEE','ASSISTANT',NULL ,'13-JUN-65',900000,'B007');
INSERT INTO PROPERTYFORRENT
VALUES('PV94','16 HOLHEAD','ABERDEEN','AB7 5SU','HOUSE',6,650,'CO46','SA9','B007');
INSERT INTO PROPERTYFORRENT
VALUES('PL54','6 LOST ST','LONDON','NW2','DUMP',4,400,'CO87','SL41','B005');
INSERT INTO PROPERTYFORRENT
VALUES('P14','6 LAWRENCE ST','GLASGOW','G11 9QX','FLAT',33,350,'CO40',' ',' ');
INSERT INTO PROPERTYFORRENT
VALUES('PG56','2 MANOR RD','GLASGOW','G12','HOUSE',0,600,'CO87','SG37',B004);
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','SMART','848-1825','FLAT','350');
INSERT INTO CLIENT
VALUES('CR94','MATT','RITCH','111111392178','HOUSE',750); 
INSERT INTO CLIENT
VALUES('CR82','MARY','TREGEAR','01224-196720','FLAT',0); 
INSERT INTO PRIVATEOWNER
VALUES('46','JOE','KEOGH','2 FERGUS DR, ABERDEEN AB2 7SX','01224-861212');
INSERT INTO PRIVATEOWNER
VALUES(' CD34','CARL','FAR','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('CR56','PA14','14-MAY-21','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',''14-MAY-02,'  ');
INSERT INTO REGISTRATION
VALUES('CR76','B005','  '','3-JAN-45');
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','B017',NULL,'7-MAR-00');


Answer the following queries after the database has been created.
1.	List the names of clients who did not view any properties.
2.	What is the average rent for our properties?
3.	List all the properties and the number of times each was viewed.
4.	Name the owner who has the most properties listed with us.
5.	What is the average number of rooms in a rental?
6.	What is the average age of our staff?
7.	Do we have available the correct types of properties for rent?
8.	Which is the least active branch?

From a business perspective, is the information presented as answers above correct?  Explain.


Deliverables:
1.	Copy of table creation file.
2.	List of insert statements with comments on records that could not be inserted.  Include 
changes made to the record.
3.	SQL commands used to retrieve question answers and answers given in Oracle.
4.	Final explanation.