Complete and print the following SQL transactions. Log your statements and resul

Question

Complete and print the following SQL transactions. Log your statements and results by spooling your file (with echo on from Oracle if available).

Add 3 new rooms:

Room Num     Room Type

301                  D

303                  D

304                  KS

ResDetail Customer CustlD CustFName CustLName CustPhone CustType LoyaltylD Reservation ResID CheckinDate CheckOutDate CustID AgentID ReslD Room CustType CustType CustTypeDesc RoomNum RateType RateAmt RoomType Agent AgentlD AgentFName AgentLName AgentType RateType RateType RateTypeDesc RoomType RoomType RoomTypeDesc AgentType AgentType AgentTypeDesc

Explanation / Answer

CODE:

UPDATE Customer

SET CustPhone = ‘214551234’

WHERE CustID = 85;

INSERT INTO Customer (CustID, CustFName, CustLName) VALUES (120, ‘Amanda’, ‘Green’)

UPDATE TABLE Reservation

SET CheckOutDate = ‘2/8/2018’

WHERE ResID = 1001;

INSERT INTO Reservation VALUES (1011, ‘3/1/2018’, ‘3/4/3018’, 120, 14);

// Updating ResDetail table

UPDATE ResDetail

SET RateType = ‘C’,

RateAmt = 89

WHERE ResID = 1003;

UPDATE ResDetail

SET RoomNum = 301,

RateType = ‘D,

Rate = 119

WHERE ResID = 1011;

UPDATE ResDetail

SET RoomNum = 303,

RateType = ‘D’,

Rate = 129

WHERE ResID = 1011;

UPDATE ResDetail

SET RoomNum = 304,

RateType = ‘KS;,

Rate = 119

WHERE ResID = 1011;

COMMIT;

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.