You are a part-time employee of BeachCondo Rentals. BeachCondo Rentals provides
ID: 3627542 • Letter: Y
Question
You are a part-time employee of BeachCondo Rentals. BeachCondo Rentals provides a rental service
for condo owners who want to rent their units. The company rents units by the week. Currently, the
company keeps information about its rentals in an Excel workbook.
Design and create a database to store the rental data. Then create the necessary tables and enter
the data from the Case 1-2 BeachCondo Rentals workbook. Create an Available Rentals Report that lists the unit number,
weekly rate, and owner number.
Unit Number Bedrooms Bathrooms Sleeps Linens Weekly Rate Owner Last Name
102 1 1 2 $725 Heulbert
109 2 1 3 Y $1,100 Beamer
203 3 2 8 Y $1,450 Alonso
205 2 2.5 6 $1,200 Beamer
207 2 2 5 Y $975 Graty
308 2 2.5 6 Y $975 Graty
403 1 1 2 $750 Heulbert
405 1 1 3 $800 Alonso
501 3 3 8 Y $1,150 Beamer
511 2 1 4 Y $875 Graty
Owner Code Last Name First Name Street City State Postal Code Telephone
AB12 Alonso Bonita 281 Robin Kady TN 37670 615-555-8978
BE20 Beamer Rich 39 Oak Kadrick TN 37672 931-555-3424
GR50 Graty Mark 21 Westin Carlston TN 37673 931-555-5678
HJ05 Heulbert Joe 314 Cental Kady TN 37670 615-555-9631
MN45 Manton Mary 23 Hyde Kadrick TN 37672 931-555-7779
Explanation / Answer
I built your database. If you give me your email address, I'll send it to you.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.