Question: 16. Write the statement to drop the attribute phone from the Property table. 17. Paste the result of select from Property. 18. Write one statement

16. Write the statement to drop the attribute phone from the

16. Write the statement to drop the attribute phone from the Property table. 17. Paste the result of select from Property. 18. Write one statement to alter the table Booking to add a column, propertyNo, which: a. is an integer representing the propertyNo for each booking b. is a foreign key to the propertyNo in the Property table c. has a default value of 1 (i.e., your previous rental that all guests were subletting). 19. Paste the result of Select * from Booking. Check out the propertyNo attribute. What happened? 20. Guest 4 would like to sublet one of your new properties, property number 2 , from June 1 , 2023 until June 30, 2023 for a price of 650 . Write the insert statement. 21. Paste the results of a select from Booking. 22. Write another insert statement to insert a DIFFERENT date for guest 4 to rent a new property. But this time for a property number which does not exist in the Property table. 23. What error did you receive? Paste the error

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 General Management Questions!

1. Chen Chocolate Company's EPS in 2020 was $1.80, and in 2015 it was $1.25. The company's payout ratio is 60%, and the stock is currently valued at $37.75. Flota- tion costs for new equity will be...

I Primary Keys / Foreign Keys / Default Bring up your previous 2 assignments with the sql code: 1. Write the statements to remove (drop) the previous tables: Booking and Guest. 2. Modify your CREATE...

In SQL, Using MAMP It says it thoughout each part. It is SQL. 3. Write one statement to alter the table Booking to add a column, property No, which: a is an integer representing the property No for...

Please do not spam answer me like other chegg people have. the question is not complicated but does require you to read the SQL table which I have created and supplied to answer the question....

Done on phpMyAdmin + SQL, you can make your own Guest and Booking as examples. . Part 1: Primary Keys / Foreign Keys / Default Bring up your previous 2 assignments with the SQL code: 1. Write the...

Done on phpMyAdmin + SQL Booking Guest . Part 1: Primary Keys / Foreign Keys / Default Bring up your previous 2 assignments with the SQL code: 1. Write the statements to remove (drop) the previous...

Part 3: Alter 1. First, write a statement to insert into Property a new entry with unique id 4 without specifying a phone number. You will need to specify the columns you are inserting values into....

Q) Please use the following GARDEN database to answer questions. ( 20 Pts) Location -------- Name Sunlight LocationID Water .80 0 1 Gardener -------- | GardenerID Name 1 1 0 Mother 1 1 Father 1 1 2...

Part 1: Primary Keys / Foreign Keys / Default Bring up your previous 2 assignments with the SQL code: 1. Write the statements to remove (drop) the previous tables: Booking and Guest 2. Write new...

needed a bit of help on the ones I got wrong or why I got them wrong I wasnt given an ER diagram to do this. this was all the information I received. Question 1 0/2 points In order to be used as a...

Identify overlap between the different business models identified by Timmers (1999). Can you group the different business models into different types of services? Do you think these business models...

What sort of problems generally occur with a firms existing CRM applications?

A SBE taxpayer conducts business, but does not elect to use the simplified depreciation rules. The taxpayer purchases equipment for business use on 1 August 2 0 2 3 , and the equipment has an...

please answer only if you know programming language is c++ For this lab, your objective is to define the functions below. Define the void function SwapNodes () that takes three generic type Node...