ServiceCategory CategoryNum CategoryDescription 1 Plumbing 2 Heating/Air Conditioning 3 Painting 4 Electrical Systems 5 Сагрentry 6 Janitorial 1-25 ServiceRequest Service Condo Category Description Status Est Spent Next Hours Hours ServiceDate 2 10/12/2015 ID ID Num 1 Back wall in pantry has mold indicating water seepage. Diagnose and repair. Service rep has verified the problem. Plambing contractor has been called. 2 Air conditioning Service rep has verified problem. Air conditioning contractor has been called. 10/12/2015 doesn't cool. 6 Hardwood floors must be refinished. Service call has been 10/16/2015 scheduled. 4 Switches in kitchen and Open 10/13/2015 adjoining dining room are reversed. 5 Molding in pantry must be replaced. Cannot schedule until water leak is corrected. 3 Unit needs to be repainted Scheduled due to previous tenant damage. 14 10/19/2015 4 Tenant complained that Service rep unable to duplicate problem. Tenant to notify condo management if problem 11 using microwave caused short circuits on two occasions. recurs. 3 Kitchen must be repainted. Scheduled 10/16/2015
ServiceCategory CategoryNum CategoryDescription 1 Plumbing 2 Heating/Air Conditioning 3 Painting 4 Electrical Systems 5 Сагрentry 6 Janitorial 1-25 ServiceRequest Service Condo Category Description Status Est Spent Next Hours Hours ServiceDate 2 10/12/2015 ID ID Num 1 Back wall in pantry has mold indicating water seepage. Diagnose and repair. Service rep has verified the problem. Plambing contractor has been called. 2 Air conditioning Service rep has verified problem. Air conditioning contractor has been called. 10/12/2015 doesn't cool. 6 Hardwood floors must be refinished. Service call has been 10/16/2015 scheduled. 4 Switches in kitchen and Open 10/13/2015 adjoining dining room are reversed. 5 Molding in pantry must be replaced. Cannot schedule until water leak is corrected. 3 Unit needs to be repainted Scheduled due to previous tenant damage. 14 10/19/2015 4 Tenant complained that Service rep unable to duplicate problem. Tenant to notify condo management if problem 11 using microwave caused short circuits on two occasions. recurs. 3 Kitchen must be repainted. Scheduled 10/16/2015
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
Related questions
Question
List the location number and unit number for every condo whose square footage is
equal to or less than 1,084 square feet.
![1-24
ServiceCategory
CategoryNum CategoryDescription
1 Plumbing
2 Heating/Air Conditioning
3 Painting
4 Electrical Systems
5 Carpentry
6 Janitorial
1-25
ServiceRequest
Service Condo Category Description
|Status
Est
Spent Next
Hours Hours ServiceDate
2 10/12/2015
ID
ID
Num
1 Back wall in pantry has
mold indicating water
seepage. Diagnose and
repair.
Service rep has verified the
problem. Plumbing
4
contractor has been called.
2 Air conditioning
1 10/12/2015
Service rep has verified
problem. Air conditioning
contractor has been called.
2
5
3
doesn't cool.
4
6 Hardwood floors
Service call has been
10/16/2015
must be refinished.
scheduled.
4.
1
4 Switches in kitchen and
Орen
1
10/13/2015
adjoining dining room
are reversed.
5 Molding in pantry must
be replaced.
2
Cannot schedule until
2
water leak is corrected.
3 Unit needs to be repainted Scheduled
due to previous tenant
damage
6.
14
7
10/19/2015
4 Tenant complained that
using microwave caused
short circuits on two
7
11
Service rep unable to
duplicate problem.
Tenant to notify condo
management if problem
1
occasions
recurs
10/16/2015
3 Kitchen must be repainted. Scheduled
Walls discolored due to
5
kitchen fire.
9.
6 Shampoo all carpets.
Орen
10/19/2015
10
9
5 Repair window sills.
Scheduled
10/20/2015](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff27854cd-5d9f-4553-a6c0-a306ccf4a4ef%2F75bede5a-c7ec-425e-bbd8-c61a5e00d33e%2Fychblth_processed.png&w=3840&q=75)
Transcribed Image Text:1-24
ServiceCategory
CategoryNum CategoryDescription
1 Plumbing
2 Heating/Air Conditioning
3 Painting
4 Electrical Systems
5 Carpentry
6 Janitorial
1-25
ServiceRequest
Service Condo Category Description
|Status
Est
Spent Next
Hours Hours ServiceDate
2 10/12/2015
ID
ID
Num
1 Back wall in pantry has
mold indicating water
seepage. Diagnose and
repair.
Service rep has verified the
problem. Plumbing
4
contractor has been called.
2 Air conditioning
1 10/12/2015
Service rep has verified
problem. Air conditioning
contractor has been called.
2
5
3
doesn't cool.
4
6 Hardwood floors
Service call has been
10/16/2015
must be refinished.
scheduled.
4.
1
4 Switches in kitchen and
Орen
1
10/13/2015
adjoining dining room
are reversed.
5 Molding in pantry must
be replaced.
2
Cannot schedule until
2
water leak is corrected.
3 Unit needs to be repainted Scheduled
due to previous tenant
damage
6.
14
7
10/19/2015
4 Tenant complained that
using microwave caused
short circuits on two
7
11
Service rep unable to
duplicate problem.
Tenant to notify condo
management if problem
1
occasions
recurs
10/16/2015
3 Kitchen must be repainted. Scheduled
Walls discolored due to
5
kitchen fire.
9.
6 Shampoo all carpets.
Орen
10/19/2015
10
9
5 Repair window sills.
Scheduled
10/20/2015
![1-21
Location
LocationNum LocationName
Address
State PostalCode
1 Solmaris Ocean
City
| 100 Ocean Ave.
Bowton
FL
31313
2 Solmaris Bayside 405 Bayside Blvd. Glander Bay FL
31044
1-22
Owner
Address
| 100 Ocean Ave.
OwnerNum LastName FirstName
City
State PostalCode
ADO57
Adney
Bruce and Jean
Bowton
FL
31313
AN175
BL720
EL025
FE182
Anderson Bill
18 Wilcox St.
Brunswick
GA 31522
Blake
2672 Condor St.
SC 29707
Jack
Bill and Sandy
Mills
Bowton
| 7822 Coventry Dr. Rivard
Kaleva
Norton
Elend
100 Ocean Ave.
FL 31313
Feenstra
Daniel
FL 31062
JU092
KE122
NO225
Juarez
Kelly
Norton
Robinson Mike and Jane
Smeltz
Maria
892 Oak St.
FL
31521
Alyssa
527 Waters St.
|MI 49441
Peter and Caitlin 281 Lakewood Ave. Lawndale
PA 19111
RO123
900 Spring Lake Dr. Springs
MI
49456
SM072
TR222
WS032
Jim and Cathy
Michael
Henry and Karen 25 Nichols St.
32765
31044
32765
922 Garland Dr.
Lewiston
FL
Trent
405 Bayside Blvd.
Glander Bay FL
Wilson
Lewiston
FL
1-23
CondoUnit
CondolD LocationNum UnitNum SqrFt Bdrms Baths CondoFee OwnerNum
1 102
1 201
1 306
1 204
1 405
1 401
1 502
1 503
1
675
$475 AD057
1,030
1,575
1,164
1,575
| 1,030
2
1
$550 EL025
3
3
2
$625 AN175
4
2
2.
$575 BL720
3
2.
$625 FE182
6.
2
2
$550 KE122
745
1
$490 JU092
8
1,680
725
3
3
$670 RO123
9
2 A03
1
1
$190 TR222
1,084
1,084
10
2 A01
2
1
$235 NO225
2 B01
2 C01
11
2
$250 SM072
12
750
1
$190 AN175
13
2 C02
1,245
1,540
2
$250 WS032
14
2 C06
3.
2
$300 RO123](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff27854cd-5d9f-4553-a6c0-a306ccf4a4ef%2F75bede5a-c7ec-425e-bbd8-c61a5e00d33e%2Fr3zst3t_processed.png&w=3840&q=75)
Transcribed Image Text:1-21
Location
LocationNum LocationName
Address
State PostalCode
1 Solmaris Ocean
City
| 100 Ocean Ave.
Bowton
FL
31313
2 Solmaris Bayside 405 Bayside Blvd. Glander Bay FL
31044
1-22
Owner
Address
| 100 Ocean Ave.
OwnerNum LastName FirstName
City
State PostalCode
ADO57
Adney
Bruce and Jean
Bowton
FL
31313
AN175
BL720
EL025
FE182
Anderson Bill
18 Wilcox St.
Brunswick
GA 31522
Blake
2672 Condor St.
SC 29707
Jack
Bill and Sandy
Mills
Bowton
| 7822 Coventry Dr. Rivard
Kaleva
Norton
Elend
100 Ocean Ave.
FL 31313
Feenstra
Daniel
FL 31062
JU092
KE122
NO225
Juarez
Kelly
Norton
Robinson Mike and Jane
Smeltz
Maria
892 Oak St.
FL
31521
Alyssa
527 Waters St.
|MI 49441
Peter and Caitlin 281 Lakewood Ave. Lawndale
PA 19111
RO123
900 Spring Lake Dr. Springs
MI
49456
SM072
TR222
WS032
Jim and Cathy
Michael
Henry and Karen 25 Nichols St.
32765
31044
32765
922 Garland Dr.
Lewiston
FL
Trent
405 Bayside Blvd.
Glander Bay FL
Wilson
Lewiston
FL
1-23
CondoUnit
CondolD LocationNum UnitNum SqrFt Bdrms Baths CondoFee OwnerNum
1 102
1 201
1 306
1 204
1 405
1 401
1 502
1 503
1
675
$475 AD057
1,030
1,575
1,164
1,575
| 1,030
2
1
$550 EL025
3
3
2
$625 AN175
4
2
2.
$575 BL720
3
2.
$625 FE182
6.
2
2
$550 KE122
745
1
$490 JU092
8
1,680
725
3
3
$670 RO123
9
2 A03
1
1
$190 TR222
1,084
1,084
10
2 A01
2
1
$235 NO225
2 B01
2 C01
11
2
$250 SM072
12
750
1
$190 AN175
13
2 C02
1,245
1,540
2
$250 WS032
14
2 C06
3.
2
$300 RO123
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education