StayWell is an active business and already has some data collected over e-mails and phone conversations. You need to insert the following data to the OWNER and PROPERTY tables: Add the provided information to the OWNER table. Add the provided information to the PROPERTY table.

A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter7: Database Administration
Section: Chapter Questions
Problem 4TD: Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be...
icon
Related questions
icon
Concept explainers
Question

Task 2:

StayWell is an active business and already has some data collected over e-mails and phone conversations. You need to insert the following data to the OWNER and PROPERTY tables:

Add the provided information to the OWNER table.

Add the provided information to the PROPERTY table.

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
613 Old Pleasant St.
Burke
Ernest
Twin Falls
ID
83303
co103
Cole
Meerab
9486 Cirdle Ave.
Olympia
WA
98506
J0110
Jones
730 Military Ave.
98126
Ammarah
Seattle
WA
7431 S. Bishop St.
Bellingham
KO104
Kowalczyk
Jakub
WA
98226
LO108
Lopez
Janine
9856 Pumpkin Hill Ln.
Everett
WA
98213
MO100
Moore
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
Transcribed Image Text: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 613 Old Pleasant St. Burke Ernest Twin Falls ID 83303 co103 Cole Meerab 9486 Cirdle Ave. Olympia WA 98506 J0110 Jones 730 Military Ave. 98126 Ammarah Seattle WA 7431 S. Bishop St. Bellingham KO104 Kowalczyk Jakub WA 98226 LO108 Lopez Janine 9856 Pumpkin Hill Ln. Everett WA 98213 MO100 Moore 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
PROPERTY_ ID
OFFICE NUM
ADDRESS
SQR_ FT
BDRMS
FLOORS
MONTHLY_RENT
OWNER_NUM
1
30 West Thomas Rd.
1600
3.
NULL
BU106
1.
782 Queen Ln.
2100
4.
2
NULL
AK102
3.
9800 Sunbeam Ave.
1005
1
NULL
BI109
1.
105 North Illinois Rd.
1750
1.
NULL
ко104
887 Vine Rd.
1125
1.
NULL
S1105
1.
8 Laurel Dr.
2125
4
2.
NULL
MO100
7.
2
447 Goldfield St.
1675
3.
2
NULL
Co103
2
594 Leatherwood Dr.
2700
2
NULL
ко104
6.
2.
504 Windsor Ave.
700
NULL
PA101
10
2
891 Alton Dr.
1300
NULL
LO108
11
2
9531 Sherwood Rd.
1075
2
NULL
J0110
12
2 Bow Ridge Ave.
1400
3.
2
NULL
RE107
2.
2.
Transcribed Image Text:PROPERTY_ ID OFFICE NUM ADDRESS SQR_ FT BDRMS FLOORS MONTHLY_RENT OWNER_NUM 1 30 West Thomas Rd. 1600 3. NULL BU106 1. 782 Queen Ln. 2100 4. 2 NULL AK102 3. 9800 Sunbeam Ave. 1005 1 NULL BI109 1. 105 North Illinois Rd. 1750 1. NULL ко104 887 Vine Rd. 1125 1. NULL S1105 1. 8 Laurel Dr. 2125 4 2. NULL MO100 7. 2 447 Goldfield St. 1675 3. 2 NULL Co103 2 594 Leatherwood Dr. 2700 2 NULL ко104 6. 2. 504 Windsor Ave. 700 NULL PA101 10 2 891 Alton Dr. 1300 NULL LO108 11 2 9531 Sherwood Rd. 1075 2 NULL J0110 12 2 Bow Ridge Ave. 1400 3. 2 NULL RE107 2. 2.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr