StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice.
StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a
- For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address.
- For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate.
- For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.
|
|
Transcribed Image Text:SERVICE_REQUEST
SERVICE_ PROPERTY_ CATEGORY_ OFFICE DESCRIPTION
EST
SPENT NEXT
STATUS
ID
ID
NUMBER
NUM
HOURS
HOURS SERVICE DATE
11
2
The second
Problem has
11/01/2019
bedroom
been confirmed.
upstairs is not
heating up at
night.
Central heating
engineer has
been scheduled.
1
Scheduled
A new strip light
is needed for the
10/02/2019
kitchen.
The bathroom
Service rep has
3
11/09/2019
door does not
elose properly.
confirmed issue.
Scheduled to
be refitted.
New outlet has been Scheduled
requested for the
first upstairs
bedroom. (There is
currently no outlet).
10/02/2019
New paint job
requested for the
8.
3.
Орen
10
common area
(lounge).
Shower is
10/07/2019
dripping
when not in use.
Problem
confirmed.
Plumber has
been scheduled.
2
10/09/2019
Heating unit in
the entrance
smells like
it's burning
Service rep
confirmed the
issue to be dust
in the heating unit.
To be cleaned.
Kitchen sink
does not drain
properly.
New sofa requested. Open
11/12/2019
Problem
confirmed.
Plumber scheduled.
9.
12
6.
FIGURE 1-8 Sample service request category
2.
2.
2.
Transcribed Image Text:RESIDENTS
RESIDENT_ID FIRST_NAME SURNAME
1
1
PROPERTY_ID
1
Albie
O'Ryan
Tariq
Khan
3
Ismail
Salib
1
Callen
Beck
Milosz
Polansky
Ashanti
Lucas
Randy
Woodrue
8.
Aislinn
Lawrence
3
Monique
French
3.
10
Amara
Dejsuwan
4
12
Rosalie
Blackmore
4
13
Carina
Britton
4
14
Valentino
Ortega
15
Kaylem
Kent
Alessia
Wagner
Galvan
16
17
Тyrone
18
Constance
Fleming
19
Eamonn
Bain
20
Misbah
Yacob
21
Gianluca
Esposito
22
Elinor
Lake
7
23
Ray
Rosas
8
24
Damon
Caldwell
8.
25
Dawood
Busby
8
26
Dora
Harris
8
27
Leroy
Stokes
8
28
Tamia
Hess
9.
29
Amelia
Sanders
9.
30
Zarah
Вyers
10
31
Sara
Farrow
10
32
Delilah
Roy
10
33
Dougie
McDaniel
11
34
Tahir
Halabi
11
35
Mila
Zhikin
12
36
Glenn
Donovan
12
37
Zayn
Fowler
12
FIGURE 1-9 Sample data for StayWell residents
67
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY