Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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. 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.

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. 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.

Database System Concepts
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
See similar textbooks
icon
Related questions
Question
100%

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.

  1. 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.
  2. 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.
  3. 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.
OFFICE OFFICE NUM OFFICE_NAME ADDRESS CITY STATE ZIP CODE 1135 %. Wells Avense Columbia City Seattle WA 98118 986 8. Madison Rd Georgetown Seattle WA FIGURE 1-4 Sample data for StayWell offices OWNER OWNER_NUM LAST_NAME FIRST NAME Moore Elle-May Aksoy Kowalczyk 1 2 PAIGI AK102 KO104 RE107 LOTON B1109 JO110 3 Stay Well-Columbia City Stay Well-Georgetown 11 Burke Loper 3 PROPERTY PROPERTY_ID OFFICE_NUM ADDRESS Ceyda Meerd Jakub 1 Ement Nicole 9856 Pumpkin Hill Ln. Everett 7990 Willow Dr. New York 730 Mitary Ave FIGURE 1-5 Sample data for the owners of StayWell properties 2 1997 Vine d Laund Dr. Khanh Ng 994 Led 504 Winder Ave 30 West Thomas Rd. 1,600 752 CL Plumbing Heating Painting Electrical systems ADDRESS 8000 W. Newport Ave. 7337 Shelld 411 Griffin Rd. 956 Cicle Are 7431 8. Bishop 527 Primrose Rd. 613 Old Pleasant. 1 2 Bow Ave FIGURE 1-6 Sample data for StayWell properties SERVICE_CATEGORY CATEGORY_NUM CATEGORY_DESCRIPTION 1 The Id 2,100 4 1005 2 SERVICE REQUEST SERVICE PROPERTY CATEGORY OFFICE DESCRIPTION NUMBER HUM www Ma 1,125 2 2.1254 www 2,700 3 700 2 1,075 2 (engl AREA Iedo (Then New J re SOR FT BORMS FLOORS MONTHLY RENT OWNER MUM FIGURE 1-8 Sample service request category Heating witin the entrance it's burning Open 1 Pad STATUS 1 A Faberk do not drain properly. Newropted Open 1 1 1 Carpentry Furniture replacement FIGURE 1-7 Sample category data for StayWell maintenance services CITY STATE NV WA Seattle WA Olympia WA Bellingham WA Portland OR Twin Falls freed To be deased confirmed WA WA NY WA 10 1 0 L ZIP CODE MISOS 0 131 0 KUMU 0 98213 98126 SPENT NEXT HOURS HOURS SERVICE DATE 1,5 K 120 9 wwwwwwww 2000 MOD 2,750 KOL 1,050 PA301 1100 0110 1,700 107 1000/2000 110/2009 10002009 1007/2009 10/09/2009 11/12/2009
Transcribed Image Text:OFFICE OFFICE NUM OFFICE_NAME ADDRESS CITY STATE ZIP CODE 1135 %. Wells Avense Columbia City Seattle WA 98118 986 8. Madison Rd Georgetown Seattle WA FIGURE 1-4 Sample data for StayWell offices OWNER OWNER_NUM LAST_NAME FIRST NAME Moore Elle-May Aksoy Kowalczyk 1 2 PAIGI AK102 KO104 RE107 LOTON B1109 JO110 3 Stay Well-Columbia City Stay Well-Georgetown 11 Burke Loper 3 PROPERTY PROPERTY_ID OFFICE_NUM ADDRESS Ceyda Meerd Jakub 1 Ement Nicole 9856 Pumpkin Hill Ln. Everett 7990 Willow Dr. New York 730 Mitary Ave FIGURE 1-5 Sample data for the owners of StayWell properties 2 1997 Vine d Laund Dr. Khanh Ng 994 Led 504 Winder Ave 30 West Thomas Rd. 1,600 752 CL Plumbing Heating Painting Electrical systems ADDRESS 8000 W. Newport Ave. 7337 Shelld 411 Griffin Rd. 956 Cicle Are 7431 8. Bishop 527 Primrose Rd. 613 Old Pleasant. 1 2 Bow Ave FIGURE 1-6 Sample data for StayWell properties SERVICE_CATEGORY CATEGORY_NUM CATEGORY_DESCRIPTION 1 The Id 2,100 4 1005 2 SERVICE REQUEST SERVICE PROPERTY CATEGORY OFFICE DESCRIPTION NUMBER HUM www Ma 1,125 2 2.1254 www 2,700 3 700 2 1,075 2 (engl AREA Iedo (Then New J re SOR FT BORMS FLOORS MONTHLY RENT OWNER MUM FIGURE 1-8 Sample service request category Heating witin the entrance it's burning Open 1 Pad STATUS 1 A Faberk do not drain properly. Newropted Open 1 1 1 Carpentry Furniture replacement FIGURE 1-7 Sample category data for StayWell maintenance services CITY STATE NV WA Seattle WA Olympia WA Bellingham WA Portland OR Twin Falls freed To be deased confirmed WA WA NY WA 10 1 0 L ZIP CODE MISOS 0 131 0 KUMU 0 98213 98126 SPENT NEXT HOURS HOURS SERVICE DATE 1,5 K 120 9 wwwwwwww 2000 MOD 2,750 KOL 1,050 PA301 1100 0110 1,700 107 1000/2000 110/2009 10002009 1007/2009 10/09/2009 11/12/2009
RESIDENTS RESIDENT_ID FIRST_NAME SURNAME O'Ryan Khan Salib Beck 1 5 7 10 12 13 14 15 16 17 18 KRIEKESNENKANENERGI 19 20 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Albic Tariq Ismail Callen Milosz Ashanti 36 37 Randy Aislinn Monique Amara Rosalie Carina Valentino Kaylem Alessia Tyrone Constance Eamonn Misbah Gianluca Elinor Ray Damon Dawood Dora Leroy Tamia Amelia Zarah Sara Delilah Dougle Tahir Mila Glenn Zayn Polansky Lucas Woodrue Lawrence French Britton Ortega Kent Wagner Galvan Fleming Dejsuwan 4 Blackmore Bain Yacob Esposito Lake Rosas Caldwell Busby Harris Stokes Hess PROPERTY ID Sanders Byers Farrow Roy McDaniel Halabi Zhikin 1 1 1 2 2 2 2 3 3 4 4 5 5 6 6 6 6 7 7 7 8 8 8 8 8 9 9 10 10 10 11 11 12 12 12 Donovan Fowler FIGURE 1-9 Sample data for StayWell residents
Transcribed Image Text:RESIDENTS RESIDENT_ID FIRST_NAME SURNAME O'Ryan Khan Salib Beck 1 5 7 10 12 13 14 15 16 17 18 KRIEKESNENKANENERGI 19 20 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Albic Tariq Ismail Callen Milosz Ashanti 36 37 Randy Aislinn Monique Amara Rosalie Carina Valentino Kaylem Alessia Tyrone Constance Eamonn Misbah Gianluca Elinor Ray Damon Dawood Dora Leroy Tamia Amelia Zarah Sara Delilah Dougle Tahir Mila Glenn Zayn Polansky Lucas Woodrue Lawrence French Britton Ortega Kent Wagner Galvan Fleming Dejsuwan 4 Blackmore Bain Yacob Esposito Lake Rosas Caldwell Busby Harris Stokes Hess PROPERTY ID Sanders Byers Farrow Roy McDaniel Halabi Zhikin 1 1 1 2 2 2 2 3 3 4 4 5 5 6 6 6 6 7 7 7 8 8 8 8 8 9 9 10 10 10 11 11 12 12 12 Donovan Fowler FIGURE 1-9 Sample data for StayWell residents
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Database Development
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
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
SEE MORE TEXTBOOKS