Report also. Tables provided create two store procedures and define the business reasons for them.usetables. P VRENTAL_IDDESCRIPTIONCOMPLETE_ADDRESS* OWNER_NAMEOWNER_EMAILOWNER PHONEOTHER DETAILSVACATION RENTALNUMBER (10)VARCHAR2 (50 BYTE)VARCHAR2 (100 BYTE)VARCHAR2 (50 BYTE)VARCHAR2 (100 BYTE)CHAR (10 BYTE)VARCHAR2 (100 BYTE)HOLIDAY_HOME_PK (VRENTAL_ID)◆ HOLIDAY_HOME_PK (VRENTAL_ID)PF VRENTAL_IDPF" AMENITY_CODEVRENTAL_AMENITYPF* PROPERTY_IDNUMBER (10)PF PROPERTY_UNIT_NUMBER CHAR (8 BYTE)P STATUS_DATEDATEFNUMBER (10)CHAR (5 BYTE)OTHER DETAILS VARCHAR2 (100 BYTE)PROPERTY_AMENITY_PK (VRENTAL_ID, AMENITY_CODE)FK PROPERTY_AMENITY_TO_AMENITY (AMENITY_CODE)FK_PROPERTY_AMENITY_TO_VRENTAL (VRENTAL_ID)PROPERTY_AMENITY_PK (VRENTAL_ID, AMENITY_CODE)BOOKING IDNUMBER (10)CHAR (1 BYTE)PROPERTY_STATUS_PK (PROPERTY_ID, PROPERTY_UNIT_NUMBER, STATUS_DATE)* AVAILABLEFK_PROPERTY_STATUS_TO_BOOKING (BOOKING_ID)FK_PROPERTY_STATUS_TO_PROPERTY (PROPERTY_ID, PROPERTY_UNIT_NUMBER)PROPERTY_STATUSPROPERTY_STATUS_PK (PROPERTY_ID, PROPERTY_UNIT_NUMBER, STATUS_DATE)KPF PROPERTY_IDP PROPERTY_UNIT_NUMBER* PROPERTY TYPE.* BATHROOM_COUNT* BEDROOM_COUNTROOM_COUNT* SLEEPS HOW MANYOTHER DETAILSPROPERTYNUMBER (10)CHAR (8 BYTE)VARCHAR2 (50 BYTE)NUMBER (3.1)NUMBER (3)VARCHAR2 (100 BYTE)PROPERTY_PK (PROPERTY_ID. PROPERTY_UNIT_NUMBER)NUMBER (2,1)NUMBER (2)PAMENITY_CODEFK_PROPERTY_TO_VRENTAL (PROPERTY_ID)PROPERTY_PK (PROPERTY_ID, PROPERTY_UNIT_NUMBER)AMENITYCHAR (5 BYTE)AMENITY_DESCRIPTION VARCHAR2 (100 BYTE)AMENITY_PK (AMENITY_CODE)AMENITY PK (AMENITY_CODE)P BOOKING_IDFPROPERTY_IDF.* PROPERTY_UNIT_NUMBER.KGUEST_ID* BOOKING_STATUS* BOOKING_STATUS_CHANGE_DATEBOOKING START* BOOKING_ENDOTHER DETAILSBOOKING_PK (BOOKING_ID)BOOKING_PK (BOOKING_ID)P GUEST_IDBOOKINGGUEST_FIRST_NAMEGUEST_LAST_NAMENUMBER (10)NUMBER (10)CHAR (8 BYTE)FK_BOOKING_TO_GUEST (GUEST_ID)FK_BOOKING_TO_PROPERTY (PROPERTY_ID, PROPERTY_UNIT_NUMBER)NUMBER (10)VARCHAR2 (25 BYTE)DATEDATEDATEVARCHAR2 (100 BYTE). DOB* DRIVERS_LICENSE STATE* DRIVERS LICENSE_NOOTHER DETAILSGUEST_PK (GUEST_ID)GUEST_PK (GUEST_ID)GUESTNUMBER (10)VARCHAR2 (50 BYTE)VARCHAR2 (50 BYTE)DATECHAR (2 BYTE)VARCHAR2 (15 BYTE)VARCHAR2 (100 BYTE)

Question

Report also. Tables provided create two store procedures and define the business reasons for them.usetables. P VRENTAL_IDDESCRIPTIONCOMPLETE_ADDRESS* OWNER_NAMEOWNER_EMAILOWNER PHONEOTHER DETAILSVACATION RENTALNUMBER (10)VARCHAR2 (50 BYTE)VARCHAR2 (100 BYTE)VARCHAR2 (50 BYTE)VARCHAR2 (100 BYTE)CHAR (10 BYTE)VARCHAR2 (100 BYTE)HOLIDAY_HOME_PK (VRENTAL_ID)◆ HOLIDAY_HOME_PK (VRENTAL_ID)PF VRENTAL_IDPF&#34; AMENITY_CODEVRENTAL_AMENITYPF* PROPERTY_IDNUMBER (10)PF PROPERTY_UNIT_NUMBER CHAR (8 BYTE)P STATUS_DATEDATEFNUMBER (10)CHAR (5 BYTE)OTHER DETAILS VARCHAR2 (100 BYTE)PROPERTY_AMENITY_PK (VRENTAL_ID, AMENITY_CODE)FK PROPERTY_AMENITY_TO_AMENITY (AMENITY_CODE)FK_PROPERTY_AMENITY_TO_VRENTAL (VRENTAL_ID)PROPERTY_AMENITY_PK (VRENTAL_ID, AMENITY_CODE)BOOKING IDNUMBER (10)CHAR (1 BYTE)PROPERTY_STATUS_PK (PROPERTY_ID, PROPERTY_UNIT_NUMBER, STATUS_DATE)* AVAILABLEFK_PROPERTY_STATUS_TO_BOOKING (BOOKING_ID)FK_PROPERTY_STATUS_TO_PROPERTY (PROPERTY_ID, PROPERTY_UNIT_NUMBER)PROPERTY_STATUSPROPERTY_STATUS_PK (PROPERTY_ID, PROPERTY_UNIT_NUMBER, STATUS_DATE)KPF PROPERTY_IDP PROPERTY_UNIT_NUMBER* PROPERTY TYPE.* BATHROOM_COUNT* BEDROOM_COUNTROOM_COUNT* SLEEPS HOW MANYOTHER DETAILSPROPERTYNUMBER (10)CHAR (8 BYTE)VARCHAR2 (50 BYTE)NUMBER (3.1)NUMBER (3)VARCHAR2 (100 BYTE)PROPERTY_PK (PROPERTY_ID. PROPERTY_UNIT_NUMBER)NUMBER (2,1)NUMBER (2)PAMENITY_CODEFK_PROPERTY_TO_VRENTAL (PROPERTY_ID)PROPERTY_PK (PROPERTY_ID, PROPERTY_UNIT_NUMBER)AMENITYCHAR (5 BYTE)AMENITY_DESCRIPTION VARCHAR2 (100 BYTE)AMENITY_PK (AMENITY_CODE)AMENITY PK (AMENITY_CODE)P BOOKING_IDFPROPERTY_IDF.* PROPERTY_UNIT_NUMBER.KGUEST_ID* BOOKING_STATUS* BOOKING_STATUS_CHANGE_DATEBOOKING START* BOOKING_ENDOTHER DETAILSBOOKING_PK (BOOKING_ID)BOOKING_PK (BOOKING_ID)P GUEST_IDBOOKINGGUEST_FIRST_NAMEGUEST_LAST_NAMENUMBER (10)NUMBER (10)CHAR (8 BYTE)FK_BOOKING_TO_GUEST (GUEST_ID)FK_BOOKING_TO_PROPERTY (PROPERTY_ID, PROPERTY_UNIT_NUMBER)NUMBER (10)VARCHAR2 (25 BYTE)DATEDATEDATEVARCHAR2 (100 BYTE). DOB* DRIVERS_LICENSE STATE* DRIVERS LICENSE_NOOTHER DETAILSGUEST_PK (GUEST_ID)GUEST_PK (GUEST_ID)GUESTNUMBER (10)VARCHAR2 (50 BYTE)VARCHAR2 (50 BYTE)DATECHAR (2 BYTE)VARCHAR2 (15 BYTE)VARCHAR2 (100 BYTE)

Accepted Answer

The answer is below: