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 receiveany points 1. The query in text format (used by the instructor

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!