Superflex Apartment Database: Create a Web Page to display a list of apartments that have been rented by various staff (use HTML table tag). For each staff member, the Web page either displays the apartment number/numbers or the message "No Apartment Rented" if there is no associated rental. The Web page layout is shown below, with attributes from the database in italics.

 

Create a PL/SQL procedure "w8_4_staff_apartment_details" that displays the data required for the table. Use the procedure code to complete the Web page.

 

The results should look like this:

is:

CIS528 STUDENT.RENTAL NUMBER (6) DATE CHAR(1 BYTE) VARCHAR2 (3 BYTE) P RENTAL_NO F F * RENTAL_DATE RENTAL STATUS LEASE_TYPE LEASE START LEASE END STAFF NO APT NO RENTAL_PK (RENTAL_NO) RENTAL APT_FK1 (STAFF_NO) RENTAL APT_FK2 (APT_NO) RENTAL_PK (RENTAL_NO) P STAFF NO CIS528 STUDENT.STAFF FIRST NAME LAST_NAME POSITION STATUS GENDER DATE DATE DOB SALARY VARCHAR2 (5 BYTE) NUMBER (3) VARCHAR2 (5 BYTE) VARCHAR2 (15 BYTE) VARCHAR2 (15 BYTE) VARCHAR2 (12 BYTE) CHAR (1 BYTE) CHAR(1 BYTE) DATE NUMBER (5) STAFF_PK (STAFF_NO) STAFF_PK (STAFF_NO)