As you work on Assignment$-7$ some guidance:

Make sure you understand how the Web PL$/$SQL mechanism works in the form of $($a$)$ incorporation of HTML with PL$/$SQL and $($b$)$ creation of database access descriptor $($DAD$)$ to view the Web page. $q,-$ The DAD for the Oracle department server has already been created, as mentioned in the slides and earlier announcement.

To ensure that correct database data is displayed in the Web browser, it is highly recommended that a plain PL$/$SQL procedure is created with dbms$\_$output statementc that display the data that should appear in the Web browser.

Once the plain PL$/$SQL procedure is working correctly, copy the procedure with a new procedure name $($as a Web PL$/$SQL procedure$)$ and then replace the dbms$\_$output statements with the appropriate HTML statements. Use any of the HTML Templates in the Misc Guides section on Blackboard to speed up the creation of the Web PL$/$SQL procedure.

If the plain PL$/$SQL procedure works correctly, the Web PL$/$SQL procedure will also work or display correctly in the Web browser.

Submit two procedures for the assignment: plain PL$/$SQL procedure and Web PL$/$SQL procedure.

$8-4.$ Superflex Apartment database: Create a Web page to display a list of apartments that have been rented by various staff $($use HTML table tag$).$ The Web page either displays for each staff either the apartment number or a message $"$No Apartment Rented" in case the staff has no associated rental. The Web page layout is shown below, with attributes from database in italics.

Create a PL$/$SQL procedure $"$w$8\_4\_$staff$\_$apartment$\_$details" that displays the data required for the table. Use the procedure code to complete the Web Page.$|$