Use UStayWell Student Accommodation Database to answer the following questions A. Create a LARGE_PROPERTY table with the structure shown in Figure 6-29. B. Insert into the LARGE_PROPERTY table the office number, address, bedrooms, baths, monthly rent, and owner number for those properties whose square footage is greater than 1,500 square feet. C. StayWell has increased the monthly rent of each large property by $150. Update the monthly rents in the LARGE_PROPERTY table accordingly. D. Delete all properties in the LARGE_PROPERTY table for which the owner number is BI109. E. The property in managed by Columbia City with the address 105 North Illinois Rd is in the process of being remodeled and the number of bedrooms is unknown. Change the bedrooms value in the LARGE_PROPERTY table to null. F. Add to the LARGE_PROPERTY table a new character column named OCCUPIED that is one character in length. (This column indicates whether the property is currently occupied.) Set the value for the OCCUPIED column on all rows to Y. G. Delete the LARGE_PROPERTY table from the database.
Use UStayWell Student Accommodation
A. Create a LARGE_PROPERTY table with the structure shown in Figure 6-29.
B. Insert into the LARGE_PROPERTY table the office number, address, bedrooms, baths, monthly
rent, and owner number for those properties whose square footage is greater than 1,500 square
feet.
C. StayWell has increased the monthly rent of each large property by $150. Update the monthly rents
in the LARGE_PROPERTY table accordingly.
D. Delete all properties in the LARGE_PROPERTY table for which the owner number is BI109.
E. The property in managed by Columbia City with the address 105 North Illinois Rd is in the process
of being remodeled and the number of bedrooms is unknown. Change the bedrooms value in the
LARGE_PROPERTY table to null.
F. Add to the LARGE_PROPERTY table a new character column named OCCUPIED that is one
character in length. (This column indicates whether the property is currently occupied.) Set the
value for the OCCUPIED column on all rows to Y.
G. Delete the LARGE_PROPERTY table from the database.
Step by step
Solved in 7 steps
