Isys 2263 sql deep dive - Study guides, Class notes & Summaries

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 OW...