Execute the transactions below to modify/add to the data entered in the previous step (COMMIT the transactions if not automatically committed). Print the statements and output for each transaction before proceeding to Step IV:

Customer table

Change the phone number of Customer 85 to ?2145551234?

Add Customer 120 (Amanda Green, no phone number)

Reservation table

Change the checkout date for reservation 1001 to 2/8/2018

Add a reservation:

ResID	CheckIn	CheckOut	CustID	AgentID
1011	3/1/2018	3/4/2018	120	14

ResDetail table:

Change the RateCode of ResID 1003 to C

Change the RateAmt of ResID 1003 to $89

Add the following details for reservation 1011:

RoomNum	RateType	Rate
224	W	$119
225	W	$129

Transcribed Image Text:

CustType CustType CustTypeDesc AgentType AgentType AgentTypeDesc 18 81 Customer CustID CustName CustName CustPhone CustType Loyalty D Agent AgentID AgentName Agent Name AgentType 18 18 Reservation ResiD CheckinDate Check Out Date CustID AgentiD RateType RateType RateTypeDesc 18 8 ResDetail ResID RoomNum RateType RateAmt RoomType RoomType RoomTypeDesc 181 Room RoomNum RoomType CustType CustType CustTypeDesc AgentType AgentType AgentTypeDesc 18 81 Customer CustID CustName CustName CustPhone CustType Loyalty D Agent AgentID AgentName Agent Name AgentType 18 18 Reservation ResiD CheckinDate Check Out Date CustID AgentiD RateType RateType RateTypeDesc 18 8 ResDetail ResID RoomNum RateType RateAmt RoomType RoomType RoomTypeDesc 181 Room RoomNum RoomType

Answer rating: 100% (QA)

Updating Customer table UPDATE Customer SET CustPhone 214551234 WHERE CustID ... View the full answer