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

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.
Answer each of the following questions using the StayWell Student Accommodation data shown in Figures 1-4 through 1-9 in Module 1. OFFICE OFFICE_NUM OFFICE_NAME FIGURE 1-4 Sample data for StayWell offices MO100 PA101 AK102 C0103 KO104 OWNER OWNER_NUM LAST_NAME FIRST NAME Elle-May Makesh |51105 StayWell-Columbia City StayWell-Georgetown BU106 RE107 LO108 BI109 JO110 11 Moore Patel Aksoy Cole Kowalczyk Sims Burke Redman Lopez Bianchi Jones 2 7431 S. Bishop St. 527 Primrose Rd. 613 Old Pleasant St. 7681 Fordham St. 9856 Pumpkin Hill Ln. 7990 Willow Dr. 730 Military Ave. FIGURE 1-5 Sample data for the owners of StayWell properties 1 1 2 Ceyda Meerab PROPERTY PROPERTY ID OFFICE_NUM ADDRESS Jakub Haydon Ernest Seth 2 2 2 ADDRESS AREA 1135 N. Wells Avenue Columbia City Seattle WA 986 8. Madison Rd Georgetown Seattle WA Janine Nicole Ammarah ADDRESS CITY 8006 W. Newport Ave. Reno 7337 Sheffield St. 411 Griffin Rd. 9486 Circle Ave. 30 West Thomas Rd. 782 Queen Ln. 9800 Sunbeam Ave. 105 North Illinois Rd. 887 Vine Rd. 8 Laurel Dr. 447 Goldfield St. 594 Leatherwood Dr. 504 Windsor Ave. 891 Alton Dr. Plumbing Heating Painting Electrical systems 9531 Sherwood Rd. 2 Bow Ridge Ave. FIGURE 1-6 Sample data for StayWell properties SERVICE_CATEGORY CATEGORY_NUM CATEGORY_DESCRIPTION 2 1 1 1 2 2 2 CITY STATE ZIP CODE 1 1 1 2 Seattle Seattle WA Olympia Bellingham WA Portland Twin Falls Seattle Everett New York Seattle STATE ZIP CODE NV WA WA SQR_FT BDRMS FLOORS MONTHLY RENT OWNER NUM 1,400 BU106 1,900 AK102 1,200 BI109 1,650 KO104 1,160 81105 2,050 MO100 1,600 3 2,100 4 1,005 2 1,750 3 1,125 2 2,125 4 1,675 3 2,700 5 700 2 1,300 1,075 2 1,400 3 98118 98108 OR ID WA WA NY WA 89508 98119 98131 96506 98226 97203 83303 98119 98213 10005 98126 1,700 CO103 2,750 KO104 1,050 PA101 1,600 LO 108 1,100 JO110 1,700 RE107 Carpentry Furniture replacement FIGURE 1-7 Sample category data for StayWell maintenance services
Transcribed Image Text:Answer each of the following questions using the StayWell Student Accommodation data shown in Figures 1-4 through 1-9 in Module 1. OFFICE OFFICE_NUM OFFICE_NAME FIGURE 1-4 Sample data for StayWell offices MO100 PA101 AK102 C0103 KO104 OWNER OWNER_NUM LAST_NAME FIRST NAME Elle-May Makesh |51105 StayWell-Columbia City StayWell-Georgetown BU106 RE107 LO108 BI109 JO110 11 Moore Patel Aksoy Cole Kowalczyk Sims Burke Redman Lopez Bianchi Jones 2 7431 S. Bishop St. 527 Primrose Rd. 613 Old Pleasant St. 7681 Fordham St. 9856 Pumpkin Hill Ln. 7990 Willow Dr. 730 Military Ave. FIGURE 1-5 Sample data for the owners of StayWell properties 1 1 2 Ceyda Meerab PROPERTY PROPERTY ID OFFICE_NUM ADDRESS Jakub Haydon Ernest Seth 2 2 2 ADDRESS AREA 1135 N. Wells Avenue Columbia City Seattle WA 986 8. Madison Rd Georgetown Seattle WA Janine Nicole Ammarah ADDRESS CITY 8006 W. Newport Ave. Reno 7337 Sheffield St. 411 Griffin Rd. 9486 Circle Ave. 30 West Thomas Rd. 782 Queen Ln. 9800 Sunbeam Ave. 105 North Illinois Rd. 887 Vine Rd. 8 Laurel Dr. 447 Goldfield St. 594 Leatherwood Dr. 504 Windsor Ave. 891 Alton Dr. Plumbing Heating Painting Electrical systems 9531 Sherwood Rd. 2 Bow Ridge Ave. FIGURE 1-6 Sample data for StayWell properties SERVICE_CATEGORY CATEGORY_NUM CATEGORY_DESCRIPTION 2 1 1 1 2 2 2 CITY STATE ZIP CODE 1 1 1 2 Seattle Seattle WA Olympia Bellingham WA Portland Twin Falls Seattle Everett New York Seattle STATE ZIP CODE NV WA WA SQR_FT BDRMS FLOORS MONTHLY RENT OWNER NUM 1,400 BU106 1,900 AK102 1,200 BI109 1,650 KO104 1,160 81105 2,050 MO100 1,600 3 2,100 4 1,005 2 1,750 3 1,125 2 2,125 4 1,675 3 2,700 5 700 2 1,300 1,075 2 1,400 3 98118 98108 OR ID WA WA NY WA 89508 98119 98131 96506 98226 97203 83303 98119 98213 10005 98126 1,700 CO103 2,750 KO104 1,050 PA101 1,600 LO 108 1,100 JO110 1,700 RE107 Carpentry Furniture replacement FIGURE 1-7 Sample category data for StayWell maintenance services
SERVICE REQUEST SERVICE PROPERTY CATEGORY OFFICE NUMBER HUM 5 7 8 9 10 12 13 14 15 16 17 18 19 20 FIGURE 18 Sample service request category 21 22 23 RESIDENTS RESIDENT_ID FIRST NAME SURNAME Albie Tariq Ismail Callen 24 25 26 28 29 30 31 32 33 34 35 36 37 Milosz Ashanti Randy Aisling Monique Amara Rosalie Carina Valentino Kaylem Alessia Tyrone Constance. Eamonn Misbah Gianluca Elinor Ray Damon Dawood 2 Dora Leroy Tamila Amelia Zarah Sara Delilah DESCRIPTION The second bedroom spetsin is n heating e Dougle Tahir Mila Glenn Zayn Awk The back New F bedroom (There i (kengel Shower is Beating win O'Ryan Khan Salib Beck Kitchen k property. Now Open Britton Ortega Kent Wagner Galvan Fleming Bain Yacob Esposito Lake Rosas Caldwell STATUS Busby Harris Stokes Hess Sanders Byers Farrow Roy Col nghu McDaniel Halabi Zhikin Servis Polansky 2 Lucas 2 Woodrue 2 Lawrence 3 French 3 Dejsuwan 4 Blackmore 4 Priddes wered Ph Tole des 1 1 1 2 PROPERTY ID 4 5 5 6 6 6 6 7 7 7 8 8 8 8 8 9 9 10 10 10 EST SPENT NEXT HOURS HOURS SERVICE DATE 11 11 12 12 12 10 1 Donovan Fowler FIGURE 1-9 Sample data for StayWell residents L 0 0 2 0 2 1002/2009 110/2009 10002009 1000/2009 11/12/2009
Transcribed Image Text:SERVICE REQUEST SERVICE PROPERTY CATEGORY OFFICE NUMBER HUM 5 7 8 9 10 12 13 14 15 16 17 18 19 20 FIGURE 18 Sample service request category 21 22 23 RESIDENTS RESIDENT_ID FIRST NAME SURNAME Albie Tariq Ismail Callen 24 25 26 28 29 30 31 32 33 34 35 36 37 Milosz Ashanti Randy Aisling Monique Amara Rosalie Carina Valentino Kaylem Alessia Tyrone Constance. Eamonn Misbah Gianluca Elinor Ray Damon Dawood 2 Dora Leroy Tamila Amelia Zarah Sara Delilah DESCRIPTION The second bedroom spetsin is n heating e Dougle Tahir Mila Glenn Zayn Awk The back New F bedroom (There i (kengel Shower is Beating win O'Ryan Khan Salib Beck Kitchen k property. Now Open Britton Ortega Kent Wagner Galvan Fleming Bain Yacob Esposito Lake Rosas Caldwell STATUS Busby Harris Stokes Hess Sanders Byers Farrow Roy Col nghu McDaniel Halabi Zhikin Servis Polansky 2 Lucas 2 Woodrue 2 Lawrence 3 French 3 Dejsuwan 4 Blackmore 4 Priddes wered Ph Tole des 1 1 1 2 PROPERTY ID 4 5 5 6 6 6 6 7 7 7 8 8 8 8 8 9 9 10 10 10 EST SPENT NEXT HOURS HOURS SERVICE DATE 11 11 12 12 12 10 1 Donovan Fowler FIGURE 1-9 Sample data for StayWell residents L 0 0 2 0 2 1002/2009 110/2009 10002009 1000/2009 11/12/2009
Expert 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