ISYS 2263 SQL Deep Dive Questions and Answers Latest Update 100% Correct.

Add the "916 Kent Drive" property to the PROPERTYtable. - ️️INSERT INTO PROPERTY VALUES(13, 1, '916 Kent Drive', 1200, 3, 1, NULL, 'SI105'); Create the PROPERTY table. - ️️CREATE TABLE PROPERTY ( PROPERTY_ID SMALLINT PRIMARY KEY NOT NULL, OFFICE_NUM TINYINT NOT NULL, ADDRESS VARCHAR(100) NOT NULL, SQR_FT SMALLINT NOT NULL, BDRMS TINYINT NOT NULL, FLOORS TINYINT NOT NULL, MONTHLY_RENT SMALLINT, OWNER_NUM CHAR(5) NOT NULL ); Create the OWNER table. - ️️CREATE TABLE OWNER ( OWNER_NUM CHAR(5) PRIMARY KEY NOT NULL, LAST_NAME VARCHAR(20) NOT NULL, FIRST_NAME VARCHAR(20) NOT NULL, ADDRESS VARCHAR(100) NOT NULL, CITY VARCHAR(20) NOT NULL, STATE CHAR(2) NOT NULL, ZIP_CODE CHAR(5) NOT NULL ); Add the provided information to the OWNER table. - ️️INSERT INTO OWNER VALUES('AK102','Aksoy','Ceyda','411 Griffin Rd.','Seattle','WA','98131'); INSERT INTO OWNER VALUES('BI109','Bianchi','Nicole','7990 Willow Dr.','New York','NY','10005'); INSERT INTO OWNER VALUES('BU106','Burke','Ernest','613 Old Pleasant St.','Twin Falls','ID','83303'); INSERT INTO OWNER VALUES('CO103','Cole','Meerab','9486 Circle Ave.','Olympia','WA','98506'); INSERT INTO OWNER VALUES('JO110','Jones','Ammarah','730 Military Ave.','Seattle','WA','98126'); INSERT INTO OWNER VALUES('KO104','Kowalczyk','Jakub','7431 S. Bishop St.','Bellingham','WA','98226'); INSERT INTO OWNER VALUES('LO108','Lopez','Janine','9856 Pumpkin Hill Ln.','Everett','WA','98213'); INSERT INTO OWNER VALUES('MO100','Moore','Elle-May','8006 W. Newport Ave.','Reno','NV','89508'); INSERT INTO OWNER VALUES('PA101','Patel','Makesh','7337 Sheffield St.','Seattle','WA','98119');INSERT INTO OWNER VALUES('RE107','Redman','Seth','7681 Fordham St.','Seattle','WA','98119'); INSERT INTO OWNER VALUES('SI105','Sims','Haydon','527 Primrose Rd.','Portland','OR','97203'); Add the provided information to the PROPERTY table. - ️️INSERT INTO PROPERTY VALUES(1,1,'30 West Thomas Rd.',1600,3,1,NULL,'BU106'); INSERT INTO PROPERTY VALUES(2,1,'782 Queen Ln.',2100,4,2,NULL,'AK102'); INSERT INTO PROPERTY VALUES(3,1,'9800 Sunbeam Ave.',1005,2,1,NULL,'BI109'); INSERT INTO PROPERTY VALUES(4,1,'105 North Illinois Rd.',1750,3,1,NULL,'KO104'); INSERT INTO PROPERTY VALUES(5,1,'887 Vine Rd.',1125,2,1,NULL,'SI105'); INSERT INTO PROPERTY VALUES(6,1,'8 Laurel Dr.',2125,4,2,NULL,'MO100'); INSERT INTO PROPERTY VALUES(7,2,'447 Goldfield St.',1675,3,2,NULL,'CO103'); INSERT INTO PROPERTY VALUES(8,2,'594 Leatherwood Dr.',2700,5,2,NULL,'KO104'); INSERT INTO PROPERTY VALUES(9,2,'504 Windsor Ave.',700,2,1,NULL,'PA101'); INSERT INTO PROPERTY VALUES(10,2,'891 Alton Dr.',1300,3,1,NULL,'LO108'); INSERT INTO PROPERTY VALUES(11,2,'9531 Sherwood Rd.',1075,2,1,NULL,'JO110'); INSERT INTO PROPERTY VALUES(12,2,'2 Bow Ridge Ave.',1400,3,2,NULL,'RE107');