Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Based on the above tables: a. Write a stored procedure which receives a staff number (Sno) and a rental price (Rent) as inputa, and displays the list of propertics handled by that staff, which rental price is not more than the specified rental price.

Based on the above tables: a. Write a stored procedure which receives a staff number (Sno) and a rental price (Rent) as inputa, and displays the list of propertics handled by that staff, which rental price is not more than the specified rental price.

Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter13: Views
Section: Chapter Questions
Problem 1MC
See similar textbooks
icon
Related questions
Question

solve it, please

EXERCISES Consider the following tables for the RENTAL_PROPERTY database: BRANCH (Bno, Street, Suburb, Pcode. Tel_No. Fax_No) STAFF (Sno. Fname, Lname, Address, Tel No, Position, Sex, DOB, Salary, Bno) PROPERTY_FOR_RENT (Pno, Strect, Suburb, Pcode, Type, Rooms, Rent, Ono, Sno, Bno) CLIENT (Cno, Fname, Lname, Address, Tel No, Pref Type, Max_Rent, Bno) OWNER (Ono, Frame, Lname, Addreee, Tel_No) VIEWING (Cno. Pno, Date, Comment) The data for tables BRANCH, STAFF, and PROPERTY_FOR_RENT are as follows: Microsoft Acces Eile Edk Vjow Iruert Fgrmat Records Toob Window Heb Bronch : Table Bno Street 56 Clover St Suburb Pcode Tel Ne Fax No 9662 7724 Melbourne Kaw 32 Manse Rd Bundoora Melbourne 16 Argyll St Hawthorm 3000 9662 7723 163 Main St 3101 9859 8301 9859 0231 B4 B5 B7 Recordi 4 EStaft tate Sno FName LName SA9 Mary 3803 9479 1284 9479 1212 9662 4455 3000 3122 22 Deer Rd S662 8733 9810 7444 9818 6866 Tel No Salary Addross Howe 2 Elm PI, Hawthorn 3122 63 Ashby St, Kew 3101 Beech 81 George St, Kew 3101 5 Westem Rd. Kew 3101 BnoA Position F Sox DOB Assistart 0411-942-432 Deputy 0413-983983 Snr Assistant F 19-Feb-70 127 00 00 B7 24-Mar-58 61,000.00 83 10-Nov-60 136 00.00 B3 03-Jun-40 72 000 .00 83 01-Oc-45 190 000.00 05 12 Jun 65 127 CO0.00 BE SG14 David Ford M SG37 Ann SG5 Susan Brand SL21 John 0411-412-242 Manager 19 Taylor 3, Melbourne 3000 0418-444-234 Manager 29 Melvom Rd, Eaet Kew 3102 0411 002 332 Assistart White M. SLA1 Julie Loo Raned A Preperly Fo Rent Table Pae PA14 Street Suburb Pcade Type Rooms Rent Ono Sno Bne 16 High St Hawthom 3122 House 5650.00 CO46 SA9 B7 PG16 5 Novar Rd Kew 3101 Flat 4 $450.00 Co93 SG14 03 PG21 18 Dale Rd Kew 3101 House SG00.00 CO07 SG37 03 2 Maner Rd 6 Lawrence St 6 Argyl St Kow PG36 PG4 SG37 SG14 3101 Flat Flat 3 $375.00 Co93 3. $390 00 CO40 B3 83 Kew 3101 PL94 Melboume 3000 Flat 5400 00 CO87 SL41 B5 Record: Datasheet View NUM Based on the above tables: a. Write a stored procedure which receives a staff number (Sno) and a rental price (Rent) as inputs, and displays the list of propertics handled by that ataff, which rental price is not more than the specified rental price.
Transcribed Image Text:EXERCISES Consider the following tables for the RENTAL_PROPERTY database: BRANCH (Bno, Street, Suburb, Pcode. Tel_No. Fax_No) STAFF (Sno. Fname, Lname, Address, Tel No, Position, Sex, DOB, Salary, Bno) PROPERTY_FOR_RENT (Pno, Strect, Suburb, Pcode, Type, Rooms, Rent, Ono, Sno, Bno) CLIENT (Cno, Fname, Lname, Address, Tel No, Pref Type, Max_Rent, Bno) OWNER (Ono, Frame, Lname, Addreee, Tel_No) VIEWING (Cno. Pno, Date, Comment) The data for tables BRANCH, STAFF, and PROPERTY_FOR_RENT are as follows: Microsoft Acces Eile Edk Vjow Iruert Fgrmat Records Toob Window Heb Bronch : Table Bno Street 56 Clover St Suburb Pcode Tel Ne Fax No 9662 7724 Melbourne Kaw 32 Manse Rd Bundoora Melbourne 16 Argyll St Hawthorm 3000 9662 7723 163 Main St 3101 9859 8301 9859 0231 B4 B5 B7 Recordi 4 EStaft tate Sno FName LName SA9 Mary 3803 9479 1284 9479 1212 9662 4455 3000 3122 22 Deer Rd S662 8733 9810 7444 9818 6866 Tel No Salary Addross Howe 2 Elm PI, Hawthorn 3122 63 Ashby St, Kew 3101 Beech 81 George St, Kew 3101 5 Westem Rd. Kew 3101 BnoA Position F Sox DOB Assistart 0411-942-432 Deputy 0413-983983 Snr Assistant F 19-Feb-70 127 00 00 B7 24-Mar-58 61,000.00 83 10-Nov-60 136 00.00 B3 03-Jun-40 72 000 .00 83 01-Oc-45 190 000.00 05 12 Jun 65 127 CO0.00 BE SG14 David Ford M SG37 Ann SG5 Susan Brand SL21 John 0411-412-242 Manager 19 Taylor 3, Melbourne 3000 0418-444-234 Manager 29 Melvom Rd, Eaet Kew 3102 0411 002 332 Assistart White M. SLA1 Julie Loo Raned A Preperly Fo Rent Table Pae PA14 Street Suburb Pcade Type Rooms Rent Ono Sno Bne 16 High St Hawthom 3122 House 5650.00 CO46 SA9 B7 PG16 5 Novar Rd Kew 3101 Flat 4 $450.00 Co93 SG14 03 PG21 18 Dale Rd Kew 3101 House SG00.00 CO07 SG37 03 2 Maner Rd 6 Lawrence St 6 Argyl St Kow PG36 PG4 SG37 SG14 3101 Flat Flat 3 $375.00 Co93 3. $390 00 CO40 B3 83 Kew 3101 PL94 Melboume 3000 Flat 5400 00 CO87 SL41 B5 Record: Datasheet View NUM Based on the above tables: a. Write a stored procedure which receives a staff number (Sno) and a rental price (Rent) as inputs, and displays the list of propertics handled by that ataff, which rental price is not more than the specified rental price.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Procedures in SQL
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS