Add to the LARGE_PROPERTY table a new character column named OCCUPIED that is one character in length. (This column indicates whether the property is currently occupied.) Set the value for the OCCUPIED column on all rows to Y.

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
icon
Related questions
icon
Concept explainers
Question

Add to the LARGE_PROPERTY table a new character column named OCCUPIED that is one character in length. (This column indicates whether the property is currently occupied.)

Set the value for the OCCUPIED column on all rows to Y.

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
1
782 Queen Ln.
2100
4
2
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
S1105
6
1
8 Laurel Dr.
2125
4
2
2050
MO100
7
2
447 Goldfield St.
1675
3
2
1700
Co103
8
2
594 Leatherwood Dr.
2700
2
2750
ко104
2
504 Windsor Ave.
700
2
1050
PA101
10
891 Alton Dr.
1300
3
1
1600
LO108
11
9531 Sherwood Rd.
1075
2
1
1100
J0110
12
2
2 Bow Ridge Ave.
1400
3
2
1700
RE107
Transcribed Image Text: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 1 782 Queen Ln. 2100 4 2 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 S1105 6 1 8 Laurel Dr. 2125 4 2 2050 MO100 7 2 447 Goldfield St. 1675 3 2 1700 Co103 8 2 594 Leatherwood Dr. 2700 2 2750 ко104 2 504 Windsor Ave. 700 2 1050 PA101 10 891 Alton Dr. 1300 3 1 1600 LO108 11 9531 Sherwood Rd. 1075 2 1 1100 J0110 12 2 2 Bow Ridge Ave. 1400 3 2 1700 RE107
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 4 images

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
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education