Question: NOTE: Each answer must contain the following three items to receive any points 1. The query in text format (used by the instructor to test


NOTE: Each answer must contain the following three items to receive any points 1. The query in text format (used by the instructor to test the query) 2. A screen shot or snippet of the database query, within the database simulator (right hand column in the picture below) 3. The output (bottom section of the picture below that shows the HouseOwner as John) a) SELECT HouseOwner FROM HOUSE WHERE eAddress="285 Westport Rd '; CREATE TABLE HOUSE SELECT Houseowner 2 FROM HOUSE (HouseAddreas CHAR (50), HouseOwner CHAR(30), Insurance CHAR (40)) 6 INSERT INTO OUSE VALUES '285 Westport Rd' John'es') [.892 Hello' '3111'- 'Ho'); 20 11 CR ATE TABLE HEATING UHIT 12 (HeatinUieiD INT, UnitNae CHAR(30), Unitiype CHAR (40). Manufacory CHAR (40) 14 15 26 Build Schema Edit Fullscreen / Browser t | 1 :1 Run SQL Edit Fullscreen / Format Code HouseOwner John
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
