SQL ORACLE QUESTION ResID IDENTITY 5000.1 Guest ID IDENTITY (1500,1) CREDITCARD

Question

SQL ORACLE QUESTION

ResID IDENTITY 5000.1 Guest ID IDENTITY (1500,1) CREDITCARD uires RESERVATION PK CreditCardlD smallint has- ROOM TYPE PKK GuestID smallint FK1 GuestID smallint Reservation Date date CC Type varchar(5) varchar (20) PK BeomlypelD smallint ReservationStatus. char(1) GuestFirst CC Number varchar(16) ReservationComments varchar (200 GuestLast varchar(20) CC Company varchar(40) RTDescription varchar(2000 FK1 Credit CardID smallint GuestAddress1 varchar(30) CCCard Holder varchar(40) uestAddress2 varchar (10) CCExpiration smalldatetime F Res Status: CHECK R,A,C,X has GuestCity varchar(20) Guest State char (2 DISCOUNT GuestPostal Code char(10) RACKRATE PK Discount!D smallint Guestcountry varchar(20) has DPK RackBateID Smallint Guest Phone varchar(20) Gues Email varchar (30 DiscountDescription varchar(50) FK1 Room TypeID smallint GuestComments varchar (200) ontains DiscountExpiration date FK2 HotellD smallint DiscountRules varchar(100) Rack Rate smallmoney Percent cimal(4,2) ROOM Rack Rate Begin date DiscountAmount small money PK RoomID Smallint Rack Rate End date Rack Rate Description varchar(200) has Room Number varchar(5) RoomDescription varchar(200) has Room Smoking bit Hotell D is NOT an Identity FOLIO RoomBedConfiguration char(2) HOTEL assigned H PK FoliolD Smallint FK3 HotellD smallint -has PK HotelD small in FKA RoomTypeID smallint d Config FK1 ReservationID smallint GuestIDOTRIGGER smallint CHECK HotelName varchar(30) BILLING FK2 RoomID smallint K, Q,F,20, 2K,2F HotelAddress. varchar(30) Quote Rate Smallmoney HotelCity varchar(20) Check inDate smalldatetime HotelState char(2) has- Nights. tinyint HotelCountry varchar(20) FK1 FoliollD smallint Status char(1) HotelPostalCode char(10) FK2 BillingCategorylD smallint Comments varchar (200 Hotel StarRating char(1) BillingDescription char(30) FK3 Discount ID smallint BillingAmount small money Hotel PictureLink varchar (100) FK1 TaxLocationID mallint BillingltemQty tinyint Status: CHECK has Discount: DEFAULT BillingltemDate date R.A.CX located in PAYMENT PaymentID IDENTITY con ins (8000,1) EPK PaymentID Smallint TAXRATE BILLINGCATEGORY FK1 FoliollD smallint PK Billing CategoryID smallint PaymentDate date Tax Description varchar(30) PaymentAmount smallmoney BillingCatDescription varchar(30) aymentComments varchar(200) BillingCatTaxable Ver 1.1 6/5/2017

Explanation / Answer

1. select rackrate from RACKRATE where rackratebegin=start-curdate && rackrateend=end-curdate ;
2. update rackrate set rackrate = CEIL(rackrate+(rackrate / 10), 2) where roomtypeid=1;
3. update rackrate set rackrate = FlOOR(rackrate-(rackrate / 10), 2) where roomtypeid =3 OR roomtypeid =4;  

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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