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. SERVICE_REQUESTSERVICE_ PROPERTY_ CATEGORY_ OFFICE DESCRIPTIONESTSPENT NEXTSTATUSIDIDNUMBERNUMHOURSHOURS SERVICE DATE112The secondProblem has11/01/2019bedroombeen confirmed.upstairs is notheating up atnight.Central heatingengineer hasbeen scheduled.1ScheduledA new strip lightis needed for the10/02/2019kitchen.The bathroomService rep has311/09/2019door does notelose properly.confirmed issue.Scheduled tobe refitted.New outlet has been Scheduledrequested for thefirst upstairsbedroom. (There iscurrently no outlet).10/02/2019New paint jobrequested for the8.3.Орen10common area(lounge).Shower is10/07/2019drippingwhen not in use.Problemconfirmed.Plumber hasbeen scheduled.210/09/2019Heating unit inthe entrancesmells likeit's burningService repconfirmed theissue to be dustin the heating unit.To be cleaned.Kitchen sinkdoes not drainproperly.New sofa requested. Open11/12/2019Problemconfirmed.Plumber scheduled.9.126.FIGURE 1-8 Sample service request category2.2.2. RESIDENTSRESIDENT_ID FIRST_NAME SURNAME11PROPERTY_ID1AlbieO'RyanTariqKhan3IsmailSalib1CallenBeckMiloszPolanskyAshantiLucasRandyWoodrue8.AislinnLawrence3MoniqueFrench3.10AmaraDejsuwan412RosalieBlackmore413CarinaBritton414ValentinoOrtega15KaylemKentAlessiaWagnerGalvan1617Тyrone18ConstanceFleming19EamonnBain20MisbahYacob21GianlucaEsposito22ElinorLake723RayRosas824DamonCaldwell8.25DawoodBusby826DoraHarris827LeroyStokes828TamiaHess9.29AmeliaSanders9.30ZarahВyers1031SaraFarrow1032DelilahRoy1033DougieMcDaniel1134TahirHalabi1135MilaZhikin1236GlennDonovan1237ZaynFowler12FIGURE 1-9 Sample data for StayWell residents67

For this database design, there will be 3 tables - student , property, rental. Student_no is primary…

Answered: StayWell also rents out properties on a…

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

See similar textbooks

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.

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.