Answered: Based on the above tables: a. Write a…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

solve it, please

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

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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