Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

pls using sql live plz using sql live + screanshot EXERCISES Consider the following tables for the RENTAL_PROPERTY database BRANCH (Bro Street, Suburb, Pcode, Tel_No.

image text in transcribed
pls using sql live
plz using sql live + screanshot
EXERCISES Consider the following tables for the RENTAL_PROPERTY database BRANCH (Bro Street, Suburb, Pcode, Tel_No. Fax_No) STAFF (Sto, Fname, Lname Address, Tel_No. Position, Sex, DOB, Salary, Boo PROPERTY_FOR_RENT (Pno, Street, Suburb. Poode. Type Rooms Rest. Ono Soo, Brio CLIENT CO.Fname, L.name Address, Tel_No, Pref_Type. Max_Rest, Boo) OWNER (One Frame, name, Address, Tel No) VIEWING (Cno. Pro. Date, Comment) The data for tables BRANCH, STAFF, and PROPERTY_FOR_RENT are as follows: Microlecen Forcoh ade Widow One Pede 3000 3101 Street Subuh S6 Cover Melbourne 163 Main 39 Manise Rd Borders 22 De Rd Melboum 16 All Hawth Tele 327723 9069301 909 1234 02873 9018744 Far Me S27724 0033 3091212 LES 918 GEE 3122 Film See Name Name Addrews Tel No Paulo DOB Salary one SAJ Mwy Howe2 EN Hawthom 3122 AFIE 7.0000067 SG14 David Ford 53 Alby St, w3101 04119040 D MB 6100000 B SOYAN Beech B1 Cor.3101 0413923933 Sert 10336 000 000 SG5 Sun Brands Westen Rd, Kew 3101 0411-41230 W F 03-92.000,00 B3 SL21 Jo White 19 Taylor St, Melbume 0000416-474 01-05 0000 000 SL4 Juli Lee 28 Mold Est How 10 0415-003330 F 13.5 27 000 00 e PA14 Pro Street 16 High 9 PG165Now Rd PG21 18 Dale Rd P636 2 Muros Rd PO4 Lawrence : 6 AM Record 1 Suburb Pcade Type Roma Red O Ses Be Hawthorn 3122 Home 6 S65000 COLESAB 3101 F &$150 00 0093 SG140 3101 House 5 600D 008 503 BS Kw 3101 35375 30 000 503 Kow 3101 Fiat S35000 004 S014 Melboume 3000 F SEDE COB SU 55 Based on the above tables Write a stored procedure which receives a staff number (Sno) and a rental price (Rent) as inputs, and displays the list of properties handled by that staff whach rental price is not more than the specified rental price. EXERCISES Consider the following tables for the RENTAL_PROPERTY database BRANCH (Bro Street, Suburb, Pcode, Tel_No. Fax_No) STAFF (Sto, Fname, Lname Address, Tel_No. Position, Sex, DOB, Salary, Boo PROPERTY_FOR_RENT (Pno, Street, Suburb. Poode. Type Rooms Rest. Ono Soo, Brio CLIENT CO.Fname, L.name Address, Tel_No, Pref_Type. Max_Rest, Boo) OWNER (One Frame, name, Address, Tel No) VIEWING (Cno. Pro. Date, Comment) The data for tables BRANCH, STAFF, and PROPERTY_FOR_RENT are as follows: Microlecen Forcoh ade Widow One Pede 3000 3101 Street Subuh S6 Cover Melbourne 163 Main 39 Manise Rd Borders 22 De Rd Melboum 16 All Hawth Tele 327723 9069301 909 1234 02873 9018744 Far Me S27724 0033 3091212 LES 918 GEE 3122 Film See Name Name Addrews Tel No Paulo DOB Salary one SAJ Mwy Howe2 EN Hawthom 3122 AFIE 7.0000067 SG14 David Ford 53 Alby St, w3101 04119040 D MB 6100000 B SOYAN Beech B1 Cor.3101 0413923933 Sert 10336 000 000 SG5 Sun Brands Westen Rd, Kew 3101 0411-41230 W F 03-92.000,00 B3 SL21 Jo White 19 Taylor St, Melbume 0000416-474 01-05 0000 000 SL4 Juli Lee 28 Mold Est How 10 0415-003330 F 13.5 27 000 00 e PA14 Pro Street 16 High 9 PG165Now Rd PG21 18 Dale Rd P636 2 Muros Rd PO4 Lawrence : 6 AM Record 1 Suburb Pcade Type Roma Red O Ses Be Hawthorn 3122 Home 6 S65000 COLESAB 3101 F &$150 00 0093 SG140 3101 House 5 600D 008 503 BS Kw 3101 35375 30 000 503 Kow 3101 Fiat S35000 004 S014 Melboume 3000 F SEDE COB SU 55 Based on the above tables Write a stored procedure which receives a staff number (Sno) and a rental price (Rent) as inputs, and displays the list of properties handled by that staff whach rental price is not more than the specified rental price

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Management And Supervision Wiley Ronald Institute Of Internal Auditors Professional Book Series

Authors: Gil W. Courtemanch, Guilbert W. Courtemanche

1st Edition

0471625655, 978-0471625650

More Books

Students also viewed these Accounting questions

Question

=+3. Repeat Step 2 a large number of times.

Answered: 1 week ago

Question

What magazine and ads did you choose to examine?

Answered: 1 week ago