(Solved) : Database Questions Using Oracle Given Following Relations Schema Primary Key Column S Unde Q34228513 . . . .

How to do this Database questionsusing Oracle?

Given the following Relations Schema:(Primary key column(s) are underlined, decide on the requiredforeign keys.)

Hotel(hotelNo, hotelName, city)

Room(roomNo, hotelNo, type, price)

Booking(hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest (guestNo,guestName, guestAddress)

1.. Write the DDL statement to remove all 4 tables, plus theOldBooking archive table.

[Hint: Take note ofthe deletion order of these tables; think about which ones shouldbe deleted first.]

2. Create the Hotel and Room tables with all relevant integrityconstraints, including:
   1. type (Room table) must be one of Single, Double, orFamily.
   2. price (Room table) must be between $10.00 and $100.00.
   3. room number (Room table) must
      OR

       

      PayPal Gateway not configured

      OR

       

      PayPal Gateway not configured