1) Create the DISPLAY_OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I_OWNER_NUM (provided as a parameter).Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME. 2) Create the DISPLAY_PROPERTY_OWNER procedure which obtains the office location number, address, owner number, owner first name, and owner last name for the property whose property ID is currently stored in I_PROPERTY_ID (provided as a parameter).Place these values in the variables I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME, respectively. Output the contents of I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME. may be owned by a couple or a family, only the primary contact is given.OWNER_NUMLAST_NAMEFIRST_NAMEADDRESSCITYSTATEZIP_CODEAK102AksoyCeyda411 Griffin Rd.SeattleWA98131BI109BianchiNicole7990 Willow Dr.New YorkNY10005BU106BurkeErnest613 Old Pleasant St.Twin FallsID83303| Co103CO103ColeMeerab9486 Circle Ave.Olympia98506WAJ0110JonesAmmarah730 Military Ave.SeattleWA98126ко104KowalczykJakub7431 S. Bishop St.BellinghamWA98226LO108LopezJanine9856 Pumpkin Hill Ln.EverettWA98213MO100МooreElle-May8006 W. Newport Ave.RenoNV89508PA101PatelMakesh7337 Sheffield St.SeattleWA98119RE107RedmanSeth7681 Fordham St.SeattleWA98119S1105SimsHaydon527 Primrose Rd.PortlandOR97203OWNER tableEach property at each location is identified by a property ID, as seen in the PROPERTY table.Each property also includes the office number that manages the property, address, floor size, thenumber of bedrooms, the number of floors, monthly rent per property, and the owner number. ThePROPERTY_ID is an integer unique for each property.PROPERTY_IDOFFICE_NUMADDRESSSQR FTBDRMSFLOORSMONTHLY_RENTOWNER NUM1130 West Thomas Rd.1600311400BU1062782 Queen Ln.210041900AK102319800 Sunbeam Ave.1005211200BI1094.1105 North Illinois Rd.1750311650ко10451887 Vine Rd.1125211160S1058 Laurel Dr.205061212542м0100447 Goldfield St.1675321700Co1038594 Leatherwood Dr.270052750ко1049.2504 Windsor Ave.700211050PA101102891 Alton Dr.130031600LO1081129531 Sherwood Rd.1075211100J0110122 Bow Ridge Ave.14001700RE107

Actually, database is a used to stores the data\information.

Answered: ) Create the DISPLAY_OWNER procedure…

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

Question

1) Create the DISPLAY_OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I_OWNER_NUM (provided as a parameter).

Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME.

2) Create the DISPLAY_PROPERTY_OWNER procedure which obtains the office location number, address, owner number, owner first name, and owner last name for the property whose property ID is currently stored in I_PROPERTY_ID (provided as a parameter).

Place these values in the variables I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME, respectively. Output the contents of I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME.

may be owned by a couple or a family, only the primary contact is given.
OWNER_NUM
LAST_NAME
FIRST_NAME
ADDRESS
CITY
STATE
ZIP_CODE
AK102
Aksoy
Ceyda
411 Griffin Rd.
Seattle
WA
98131
BI109
Bianchi
Nicole
7990 Willow Dr.
New York
NY
10005
BU106
Burke
Ernest
613 Old Pleasant St.
Twin Falls
ID
83303
| Co103
CO103
Cole
Meerab
9486 Circle Ave.
Olympia
98506
WA
J0110
Jones
Ammarah
730 Military Ave.
Seattle
WA
98126
ко104
Kowalczyk
Jakub
7431 S. Bishop St.
Bellingham
WA
98226
LO108
Lopez
Janine
9856 Pumpkin Hill Ln.
Everett
WA
98213
MO100
Мoore
Elle-May
8006 W. Newport Ave.
Reno
NV
89508
PA101
Patel
Makesh
7337 Sheffield St.
Seattle
WA
98119
RE107
Redman
Seth
7681 Fordham St.
Seattle
WA
98119
S1105
Sims
Haydon
527 Primrose Rd.
Portland
OR
97203
OWNER table
Each property at each location is identified by a property ID, as seen in the PROPERTY table.
Each property also includes the office number that manages the property, address, floor size, the
number of bedrooms, the number of floors, monthly rent per property, and the owner number. The
PROPERTY_ID is an integer unique for each property.
PROPERTY_ID
OFFICE_NUM
ADDRESS
SQR FT
BDRMS
FLOORS
MONTHLY_RENT
OWNER NUM
1
1
30 West Thomas Rd.
1600
3
1
1400
BU106
2
782 Queen Ln.
2100
4
1900
AK102
3
1
9800 Sunbeam Ave.
1005
2
1
1200
BI109
4.
1
105 North Illinois Rd.
1750
3
1
1650
ко104
5
1
887 Vine Rd.
1125
2
1
1160
S105
8 Laurel Dr.
2050
6
1
2125
4
2
м0100
447 Goldfield St.
1675
3
2
1700
Co103
8
594 Leatherwood Dr.
2700
5
2750
ко104
9.
2
504 Windsor Ave.
700
2
1
1050
PA101
10
2
891 Alton Dr.
1300
3
1600
LO108
11
2
9531 Sherwood Rd.
1075
2
1
1100
J0110
12
2 Bow Ridge Ave.
1400
1700
RE107

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

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