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
Question

Using the tables below – Please draw an ER- Diagram

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
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
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
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
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Storage Devices
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
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