Question: 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

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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

The median is closest to: A. 44.86. B. 46.88. C. 49.40. Consider the results of an analysis focusing on the market capitalizations of a sample of 100 firms: Bin 1 2 3 Exhibit 1: Market Capitalization...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

In this assignment, we will leverage JavaScript arrays and objects to help us explore a dataset containing real-world data. Since each person has their own interests, each student will be able to...

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...

I have to create a program in C and I can't figure it out. The program has to read a source file. Please help. /******************************************************************** PROJECT: Glossary...

- HAFH ("Home Away from Home") Realty Company leases apartments to corporate clients. HAfH flealty Company Property Management Database will keep track of HAFH buildings, apartments, corporate...

Schema for the HAFH (Home Away from Home) Realty Company. INSPECTOR table Attributes: InsID InsName Primary key (InsID) BUILDING table Attributes: BuildingID BNoOfFloors ManagerID Primary key...

category_list.php Category List Name Add Category List Products index.php category_db.php product_list.php Categories "> "> product_view.php Categories "> List Price: $ Discount: % Your Price: $ (You...

i want help with my project , here is my project , can you write the part of ( add Task and Search ) plzz in web ... plzz asab and precisely IMPORTANT NOTES - You should not in any case use any...

Part 1: Planning D Introduction Planning for a project is an important skill, so the TT284 EMA includes an element to encourage you to think about the work you will have to complete, how long the...

A terrestrial telescope has three lenses: an objective, an erecting lens, and an eyepiece. (a) Does the erecting lens (1) increase the magnification, (2) increase the physical length of the...

How can intranet expansion increase risk to an organization?

Most independent tax preparers use the following method for calculating their fee:Review LaterForm - basedHourly - basedContingent feeFlat fee

Interpret each of the following citations. a. 14 T.C. 74 (1950). b. 592 F.2d 1251 (CA5, 1979). c. 951 USTC { 50,104 (CA6, 1995). d. 75 AFTR 2d 95110 (CA6, 1995). e. 223 F.Supp. 663 (W.D. Tex., 1963).

Renaldo Ochoa is a skilled machinist who has identified a need for specialized, custom-made containers that store and move biological materials. This market is particularly active in Renaldo's...

Locate the Form 10-K for Mattel Inc. using the EDGAR database at the SEC Web site: www.sec.gov. Answer the following questions using Mattel's 2013 Form 10-K. 1. Briefly state the line of business...

On July 1, 2018, the beginning of its fiscal year, the trial balance of the general fund of the city of Wentworth was as follows: The following events occurred: a. The budget shows estimated general...

During FY 2017, the voters of Surprise County approved construction of a $21 million police facility and an $11 million fire station to accommodate the county's population growth. The construction...

Investors using the buy-and-hold technique can earn profits from an increase in stock value and from

The Consumer Financial Protection Bureau reports on consumer financial product and service complaint submissions by state, category, and company. The following table, stored in FinancialComplaints1 ,...

The annual NFL Super Bowl is the most widely watched sporting event in the United States each year. In recent years, there has been a great deal of interest in the ads that appear during the game....

Cross-classify each student in the class by gender (male, female) and current employment status (yes, no), so that the instructor can tally the results. a. Construct a table with either row or column...

8.35. A study3 of American armed forces who had served in Iraq or Afghanistan found that the event of being attacked or ambushed was reported by 1139 of 1961 Army members who had served in...

In an experiment to compare the tensile strengths of different types of copper wire, samples of each type were used. The between-samples and within-samples estimates of s2 were computed as and ,...

8.45. For a 2 X 2 table with cell counts a,b,c,d, the sample log odds ratio Iog0 has approximately a normal sampling distribution with estimated standard error = ,/i + |+ l+l. v n h c d The antilogs...