I'd like this in text form please! Some handwriting is hard for me to read.

Using the "DreamHome" database schema defined in section 4.2.6, pg. 111 and the "Staff" relation shown in Figure 4-3, pg. 112. Use the Oracle PL/SQL environment to create the "Staff" table and insert the records shown, in addition to 10 new records. Be sure to include both the "Primary Key" and the "Referential Integrity" (based on the "branchNo" foreign key and the "branchNo Primary key in the "Branch" table) in the table definition. Include a "DROP TABLE" statement as the first statement in the script. In addition, include the SQL statements that satisfy the following requirements:

1. Create a query that displays the firstname, lastname, position, salary, street, city and postal code for all employees that make more than $11,000.

2.Insert a record into the "Staff" table that includes a branch number that does not exist in the "Branch" table (i.e., this should fail if your table have been created correctly).

DreamHome schema:

Branch (branchNo, street, city, postcode)

Staff (staffNo, fName, IName, position, sex, DOB, salary,branchNo, staffNo, branchNo)

PropertyForRent (propertyNo, street, city, postcode, type, rooms, rent, ownerNo, staffNo, branchNo)

Client (clientNo, fName, IName, telNo, prefType, maxRent, eMail)

PrivateOwner (ownerNo, fName, IName, address, telNo, eMail, password)

Viewing (clientNo, propertyNo, viewDate, comment)

Registration (clientNo, branchNo, staffNo, datejoined)

Branch Table:

Staff Relation:

Branch e branchNo street city postcode se. B005 B007 B003 22 Deer Rd London SW1 4EH 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow G11 90X 32 Manse Rd Bristol BS99 INZ 56 Clover Dr London NW10 EU B004 B002 Staff Staff salary branch No sex DOB staffNo fName IName position B005 B003 SL21 SG37 B003 SG14 White Manager M Beech Assistant F Ford Supervisor M Howe Assistant F Brand Manager F Lee Assistant F John Ann David Mary Susan Julie 1-Oct-45 30000 10-Nov-60 12000 24-Mar-5818000 19-Feb-70 9000 3-Jun-40 24000 13-Jun-65 9000 B007 SA9 B003 SG5 B005 SL41