Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Company ABC wants to update its existing database to track properties, hosts, rental transactions, bookings, transaction ratings, etc. The following are notes provided by the

Company ABC wants to update its existing database to track properties, hosts, rental transactions, bookings, transaction ratings, etc.

The following are notes provided by the Company ABC:

  • Each property information includes a description, address, neighborhood, beds, and room information.
  • Each property locates in one neighborhood. A neighborhood may have many properties listed for rent.
  • Hosts are the owner of the properties. Each property has one host. A host can have multiple properties.
  • A property can be booked at different times. No double booking is allowed, which means that no property can be booked twice simultaneously.
  • Each booking is made by one guest. When a guest makes a booking, he/she should select the check-in date and check-out date. The property pricing (e.g., the price per day, guests_included, extra_people, and availability_30) is determined in the booking.
  • Guests can cancel their bookings. If a booking is canceled one day before the check-in date, the deposit payment will be refunded. A canceled booking means no transaction happened for this booking.
  • When a guest checks in, a rental transaction happened, and a connection between booking and transaction is created. Note that it is possible that a guest booked a property but did not check-in.
  • All rental transactions are paid by credit cards. It is possible that a transactions payee is not the guest.
  • Company ABC also records guests ratings of the transactions. After each transaction, the guest has the option to rate their rental experience. Company ABC keeps track of the rating and the timestamp of rating. One transaction may have multiple ratings. For example, a couple rented a transaction. After they checked out, both of them gave the ratings. Because both used the same guest_id to rate the transaction, this transaction had two ratings.
  • There are some additional concerns when you design this database.
    • Company ABC notices that some properties may have multiple rooms, and these rooms types might be different. It is possible that some properties have multiple beds, and these beds types might be different.
    • In your designed database, you should design the database to track # of beds of each bed type and # of rooms of each room type in each property.
    • Company ABC wants to use the database to track the number of properties in each neighborhood. When designing the database, this is a point to be considered.
    • Note that each credit card belongs to one payee. A payee may have multiple credit cards. Therefore, creditcard# can functional determine payee.
    • Creditcard# is sensitive data. You should not use this data as the primary key to identify each credit card.

1. Normalize the table to the 3NF tables, for each 3NF table, show all the columns of this table, underline the primary key, and indicate foreign key.

2. Recommend ways to improve database design (add entities or attributes, etc.) and explain why

3. Create ERD depicting database based off of tables

Table 1 (Transactions Table)

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Table 2 (Rankings Table)

image text in transcribed

creditcard# book 6049 2863 3518 3663 1070 7101 2419 6194 5833 9614 property_id transaction date guest_id 2515 1/5/15 G1234 2515 3/4/15 G9801 2595 1/7/15 G9817 2595 3/10/15 G2234 4573 1/2/15 G27037 4573 3/15/15 G29674 4989 1/2/15 G35199 5818 1/2/15 G38836 5818 3/17/15 G21994 5862 1/2/15 G21994 5862 3/18/15 G18431 5945 1/2/15 G55475 5945 3/19/15 G72464 6011 1/2/15 G72731 6011 3/21/15 G21994 6103 1/2/15 G92400 3/22/15 G18732 6177 1/2/15 G99128 6177 3/25/15 G100567 6628 1/2/15 G100800 6628 3/28/15 G103339 7097 1/2/15 G72464 7097 3/2/15 G106005 8025 1/3/15 G109045 8025 3/11/15 G111141 8110 1/2/15 G115673 8110 3/17/15 G7149 9-1101 22412415 0126026 guest_name guestcontact_phone payee_name Holly 110-345-9871 Holly Philip And Tania 205-654-9090 Philip And Tania Aaron 213-754-8176 Aaron Jia 123-124-7654 Jia Aaron 214-764-9870 Aaron Rosy 204-764-9871 Rosy Sandy 314-764-9872 Sandy Ivan & Wendy 215-764-9873 Ivan & Wendy Margie 208-764-9874 Margie Abhay 223-764-9875 Abhay Agnieszka 224-764-9876 Agnieszka Anne 274-764-9877 Anne Jessica And Sebouh 256-764-9878 Jessica And Sebouh Tasha 289-764-9879 Tasha Joe 223-764-9880 Joe Annette 222-764-9881 Annette Felipe 211-764-9882 Felipe Maria 244-764-9883 Maria Maria 246-764-9884 Maria Annette 255-764-9885 Annette Jaime 265-764-9886 Jaime Darren & Friends 287-764-9887 Darren & Friends Marzio 212-764-9888 Marzio Jonathan 226-764-9889 Jonathan Annette 238-764-9890 Annette Adam 254-764-9891 Adam Michael 287-764-9892 Michael Challi 209.764.9992 Shalli 7581 2755 9900 8143 7908 4989 6103 1132 8830 7663 9385 1202 7343 7359 7606 1653 7340 6406 CAZ creditcard# booking_id 6049 2863 3518 3663 1070 7101 2419 6194 5833 9614 7581 2755 9900 8143 check_in_date check_out_date 24540 1/1/15 1/5/15 95992 3/2/15 3/4/15 10065 1/1/15 1/7/15 30084 3/5/15 3/10/15 6106 1/1/15 1/2/15 75025 3/12/15 3/15/15 20147 1/1/15 1/2/15 32818 1/1/15 1/2/15 45247 3/15/15 3/17/15 89511 1/1/15 1/2/15 27949 3/15/15 3/18/15 90703 1/1/15 1/2/15 95821 3/17/15 3/19/15 19145 1/1/15 1/2/15 19145 3/18/15 3/21/15 14092 1/1/15 1/2/15 33426 3/12/15 3/22/15 10019 1/1/15 1/2/15 7604 3/20/15 3/25/15 98548 1/1/15 1/2/15 90034 3/24/15 3/28/15 96793 1/1/15 1/2/15 32825 3/1/15 3/2/15 10605 1/1/15 1/3/15 14467 3/1/15 3/11/15 92591 1/1/15 1/2/15 60443 3/13/15 3/17/15 96088 3/9/15 3/12/15 booking_date is_refunded 12/20/14 N 2/2/15 N 12/10/14 N 2/5/15 N 12/10/14 N 3/7/15 N 12/20/14 N 11/11/14 N 3/1/15 N 11/20/14 N 3/5/15 N 11/11/14 N 3/2/15 N 12/1/14 N 3/4/15 N 12/15/14 N 3/2/15 N 12/1/14 N 3/2/15 N 12/1/14 N 3/4/15 N 11/30/14 N 2/1/15 N 12/1/14 N 2/1/15 N 11/30/14 N 3/10/15 N 3/3/15 N property descriptic Stay at Chez Chic bu Stay at Chez Chic bu Midtown Castle Midtown Castle Bergen's Best! Bergen's Best! PERFECT LOCATION! Midtown Palace Midtown Palace Midtown Palace 2br Midtown Palace 2br Airy Room on the fa Airy Room on the fa House on 11th - Gar House on 11th - Gar Bergen's Best Short Bergen's Best Short Midtown Palace Suit Midtown Palace Suit ONE OF MANHATTAN ONE OF MANHATTAN Perfect for Parents, Perfect for Parents, CBG Guesthse Rm # CBG Guesthse Rm #1 CommunityBeGood CommunityBeGood CommunityBeGood 7908 4989 1132 8830 7663 9385 1202 7343 7359 7606 1653 7340 6406 5207 property description host_id host_name host_since StreetAdd neighbourhood Stay at Chez Chic buc 2758 Stephanie 976/08 Adam Clayton Powell Jr Blvd, New York, NY 10026, United State Harlem Stay at Chez Chic buc 2758 Stephanie 9/6/08 Adam Clayton Powell Jr Blvd, New York, NY 10026, United State Harlem Midtown Castle 2845 Jennifer 9/9/08 W 38 St, New York, NY 10018, United States Midtown Midtown Castle 2845 Jennifer 9/9/08 W 38 St, New York, NY 10018, United States Midtown Bergen's Best! 5871 Karen 12/31/08 Bergen St, Brooklyn, NY 11213, United States Crown Heights Bergen's Best! 5871 Karen 12/31/08 Bergen St, Brooklyn, NY 11213, United States Crown Heights PERFECT LOCATION! 7118 New-Yorker 1/26/09 10th Avenue, New York, NY 10036, United States Hell's Kitchen Midtown Palace 2845 Jennifer 9/9/08 W 54 Street, New York, NY 10019, United States Hell's Kitchen Midtown Palace 2845 Jennifer 9/9/08 W 54 Street, New York, NY 10019, United States Hell's Kitchen Midtown Palace 2br/ 2845 Jennifer 9/9/08 W 54 Street, New York, NY 10019, United States Hell's Kitchen Midtown Palace 2br/2 2845 Jennifer 9/9/08 W 54 Street, New York, NY 10019, United States Hell's Kitchen Airy Room on the fab 4267 Robin 11/12/08 W 89th St, New York, NY 10024, United States Upper West Side Airy Room on the fab 4267 Robin 11/12/08 W 89th St, New York, NY 10024, United States Upper West Side House on 11th - Gard 11481 Annette 3/26/09 11th St, Brooklyn, NY 11215, United States Gowanus House on 11th - Gard 11481 Annette 3/26/09 11th St, Brooklyn, NY 11215, United States Gowanus Bergen's Best Short St 5871 Karen 12/31/08 Bergen St, Brooklyn, NY 11213, United States Crown Heights Bergen's Best Short St 5871 Karen 12/31/08 Bergen St, Brooklyn, NY 11213, United States Crown Heights Midtown Palace Suite 2845 Jennifer 9/9/08 W 54 Street, New York, NY 10019, United States Hell's Kitchen Midtown Palace Suite 2845 Jennifer 9/9/08 W 54 Street, New York, NY 10019, United States Hell's Kitchen ONE OF MANHATTAN'S 15042 Roberto 4/27/09 West End Ave & W 91st St, New York, NY 10024, United States Upper West Side ONE OF MANHATTAN'S 15042 Roberto 4/27/09 West End Ave & W 91st St, New York, NY 10024, United States Upper West Side Perfect for Parents, V 17571 J. 5/17/09 Carlton Ave, Brooklyn, NY 11205, United States Fort Greene Perfect for Parents, V 17571 J. 5/17/09 Carlton Ave, Brooklyn, NY 11205, United States Fort Greene CBG Guesthse Rm #2. 22486 Communitybe 6/20/09 Park Place, Brooklyn, NY 11217, United States Park Slope CBG Guesthse Rm #2. 22486 Communitybe 6/20/09 Park Place, Brooklyn, NY 11217, United States Park Slope CommunityBeGoodGu 22486 Communitybe 6/20/09 Park Pl, Brooklyn, NY 11217, United States Park Slope CommunityBeGoodGu 22486 Communitybe 6/20/09 Park Pl, Brooklyn, NY 11217, United States Park Slope CommunityBeGood H 22486 Communitybe 6/20/09 Park Pl, Brooklyn, NY 11217, United States Park Slope be accommodates bathrooms bedrooms 2 2 2 2 2 1 2 1 1 1 0 0 2 6 6 2 1 1 3 2 2 1 1 2 1 1 2 5 5 2 1 2 2 city state New York NY New York NY New York NY New York NY Brooklyn NY Brooklyn NY Birmingham AL New York NY New York NY New York NY New York NY New York NY New York NY Brooklyn NY Brooklyn NY Brooklyn NY Brooklyn NY New York NY New York NY New York NY New York NY Brooklyn NY Brooklyn NY Clemson SC Clemson SC Brooklyn NY Brooklyn NY Brooklyn NY 1 zipcode latitude longitude room_type 10026 40.7992048 -73.95367575 Private room 10026 40.7992048 -73.95367575 Private room 10018 40.75362073 -73.98377381 Entire home 10018 40.75362073 -73.98377381 Entire home 11213 40.67437612 -73.93399025 Entire home 11213 40.67437612 -73.93399025 Entire home 10036 40.76260047 -73.99304499 Entire home 10019 40.76530431 -73.98521366 Private room 10020 40.765304310 -73.98521366 Private room 10019 40.76737591 -73.98646702 Entire home 10019 40.767375907 -73.98646702 Entire home 10024 40.79104614 -73.9743446 Private room 10024 40.791046138 -73.97434459 Private room 11215 40.67140381 -73.99232247 Entire home 11215 40.671403814 -73.99232246 Entire home 11213 40.67452195 -73.94109623 Entire home 11213 40.674521946 -73.941096231 Entire home 10019 40.76506179 -73.98638555 Private room 10019 40.765061792 -73.98638555, Private room 10024 40.79300035 -73.97603552 Entire home 10024 40.793000349 -73.97603551 Entire home 11205 40.69168544 -73.97184549 Entire apt 11205 40.691685444 -73.97184549. Entire apt 11217 40.67989493 -73.9779758 Private room 11217 40.679894925 -73.97797579 Private room 11217 40.68000629 -73.97864508 Private room 11217 40.68000629 -73.97864508 Private room 11217 40.680006291 -73.97864508: Private room 2 1 1 1 4 1 4 1 1 6 2 6 2 2 2 2 1 1 1 1 1 1 1 1 1 2 2 1 1 2 1 1 1 3 3 2 2 2 3 3 3 3 3 1 1 1 beds bed_type 2 Real Bed 2 Real Bed 1 Futon 1 Futon 3 Real Bed 3 Real Bed 1 Futon 1 Airbed 1 Airbed 3 Real Bed 3 Real Bed 1 Pull-out Sofa 1 Pull-out Sofa 1 Airbed 1 Airbed 3 Real Bed 3 Real Bed 1 Real Bed 1 Real Bed 1 Futon 1 Futon 1 Airbed 1 Airbed 2 Real Bed 2 Real Bed 1 Pull-out Sofa 1 Pull-out Sofa 1 Pull-out Sofa square_feet price per day guests_included extra_people transaction_amount availability_30 $59.00 2 $40.00 $236.00 $69.00 2 $30.00 $138.00 $250.00 2 $0.00 $1,500.00 $270.00 2 $0.00 $1,350.00 $220.00 6 $50.00 $200.00 $200.00 6 $60.00 $600.00 $180.00 3 $0.00 $180.00 $195.00 2 $0.00 $195.00 $200.00 2 $0.00 $400.00 $475.00 4 $75.00 $475.00 $375.00 4 $55.00 $1,025.00 144 $150.00 1 $25.00 $120.00 144 $120.00 1 $15.00 $240.00 $195.00 2 $26.00 $165.00 $165.00 2 $16.00 $495.00 1300 $240.00 6 $50.00 $200.00 1300 $200.00 6 $30.00 $2,000.00 $255.00 2 $0.00 $225.00 $225.00 2 $0.00 $1,125.00 $175.00 2 $50.00 $155.00 $155.00 2 $40.00 $620.00 $250.00 2 $50.00 $190.00 $190.00 2 $40.00 $190.00 2160 $135.00 2 $30.00 $230.00 2160 $115.00 2 $20.00 $1,150.00 $130.00 2 $30.00 $130.00 $120.00 2 $35.00 $480.00 $135.00 2 $40.00 $405.00 accumulated_host_listing_count 5 4 6 3 5 30 25 29 4 2 2 25 29 1 30 5 4 25 30 25 30 25 transaction_amount availability_30 $236.00 $138.00 $1,500.00 $1,350.00 $200.00 $600.00 $180.00 $195.00 $400.00 $475.00 $1,025.00 $120.00 $240.00 $165.00 $495.00 $200.00 $2,000.00 $225.00 $1,125.00 $155.00 $620.00 $190.00 $190.00 $230.00 $1,150.00 $130.00 $480.00 $405.00 AO U U NN ANN 26 25 26 25 30 25 28 25 25 26 30 25 30 25 30 1 1 2 2 6 5 6 5 5 rating_timestamp 4 4.5 3.5 5 3 4 5 3 3.5 3.5 4.5 2 2 property id transaction date guest_id 2515 1/5/15 G1234 2515 1/5/15 G1234 2515 1/5/15 G1234 2515 3/4/15 G9801 2595 1/7/15 G9817 2595 1/7/15 G9817 2595 1/7/15 G9817 2595 3/10/15 G2234 2595 3/10/15 G2234 4573 1/2/15 G27037 4573 3/15/15 G29674 4989 1/2/15 G35199 5818 1/2/15 G38836 5818 3/17/15 G21994 5862 1/2/15 G21994 5862 3/18/15 G18431 5945 1/2/15 G55475 5945 3/19/15 G72464 6011 1/2/15 G72731 6011 3/21/15 G21994 6103 1/2/15 G92400 6103 3/22/15 G18732 6103 3/22/15 G18732 6177 1/2/15 G99128 6177 3/25/15 G100567 6628 1/2/15 G100800 6628 3/28/15 G103339 GuestRating 1/5/15 1/6/15 1/7/15 3/4/15 1/7/15 1/7/15 1/8/15 3/10/15 3/11/15 1/2/15 3/15/15 1/2/15 1/2/15 3/17/15 1/2/15 3/18/15 1/2/15 3/19/15 1/2/15 3/21/15 1/2/15 3/22/15 3/16/15 1/2/15 3/25/15 1/2/15 3/28/15 5 3 5 4 5 2 1 5 2.5 3 5 2.5 3 4 creditcard# book 6049 2863 3518 3663 1070 7101 2419 6194 5833 9614 property_id transaction date guest_id 2515 1/5/15 G1234 2515 3/4/15 G9801 2595 1/7/15 G9817 2595 3/10/15 G2234 4573 1/2/15 G27037 4573 3/15/15 G29674 4989 1/2/15 G35199 5818 1/2/15 G38836 5818 3/17/15 G21994 5862 1/2/15 G21994 5862 3/18/15 G18431 5945 1/2/15 G55475 5945 3/19/15 G72464 6011 1/2/15 G72731 6011 3/21/15 G21994 6103 1/2/15 G92400 3/22/15 G18732 6177 1/2/15 G99128 6177 3/25/15 G100567 6628 1/2/15 G100800 6628 3/28/15 G103339 7097 1/2/15 G72464 7097 3/2/15 G106005 8025 1/3/15 G109045 8025 3/11/15 G111141 8110 1/2/15 G115673 8110 3/17/15 G7149 9-1101 22412415 0126026 guest_name guestcontact_phone payee_name Holly 110-345-9871 Holly Philip And Tania 205-654-9090 Philip And Tania Aaron 213-754-8176 Aaron Jia 123-124-7654 Jia Aaron 214-764-9870 Aaron Rosy 204-764-9871 Rosy Sandy 314-764-9872 Sandy Ivan & Wendy 215-764-9873 Ivan & Wendy Margie 208-764-9874 Margie Abhay 223-764-9875 Abhay Agnieszka 224-764-9876 Agnieszka Anne 274-764-9877 Anne Jessica And Sebouh 256-764-9878 Jessica And Sebouh Tasha 289-764-9879 Tasha Joe 223-764-9880 Joe Annette 222-764-9881 Annette Felipe 211-764-9882 Felipe Maria 244-764-9883 Maria Maria 246-764-9884 Maria Annette 255-764-9885 Annette Jaime 265-764-9886 Jaime Darren & Friends 287-764-9887 Darren & Friends Marzio 212-764-9888 Marzio Jonathan 226-764-9889 Jonathan Annette 238-764-9890 Annette Adam 254-764-9891 Adam Michael 287-764-9892 Michael Challi 209.764.9992 Shalli 7581 2755 9900 8143 7908 4989 6103 1132 8830 7663 9385 1202 7343 7359 7606 1653 7340 6406 CAZ creditcard# booking_id 6049 2863 3518 3663 1070 7101 2419 6194 5833 9614 7581 2755 9900 8143 check_in_date check_out_date 24540 1/1/15 1/5/15 95992 3/2/15 3/4/15 10065 1/1/15 1/7/15 30084 3/5/15 3/10/15 6106 1/1/15 1/2/15 75025 3/12/15 3/15/15 20147 1/1/15 1/2/15 32818 1/1/15 1/2/15 45247 3/15/15 3/17/15 89511 1/1/15 1/2/15 27949 3/15/15 3/18/15 90703 1/1/15 1/2/15 95821 3/17/15 3/19/15 19145 1/1/15 1/2/15 19145 3/18/15 3/21/15 14092 1/1/15 1/2/15 33426 3/12/15 3/22/15 10019 1/1/15 1/2/15 7604 3/20/15 3/25/15 98548 1/1/15 1/2/15 90034 3/24/15 3/28/15 96793 1/1/15 1/2/15 32825 3/1/15 3/2/15 10605 1/1/15 1/3/15 14467 3/1/15 3/11/15 92591 1/1/15 1/2/15 60443 3/13/15 3/17/15 96088 3/9/15 3/12/15 booking_date is_refunded 12/20/14 N 2/2/15 N 12/10/14 N 2/5/15 N 12/10/14 N 3/7/15 N 12/20/14 N 11/11/14 N 3/1/15 N 11/20/14 N 3/5/15 N 11/11/14 N 3/2/15 N 12/1/14 N 3/4/15 N 12/15/14 N 3/2/15 N 12/1/14 N 3/2/15 N 12/1/14 N 3/4/15 N 11/30/14 N 2/1/15 N 12/1/14 N 2/1/15 N 11/30/14 N 3/10/15 N 3/3/15 N property descriptic Stay at Chez Chic bu Stay at Chez Chic bu Midtown Castle Midtown Castle Bergen's Best! Bergen's Best! PERFECT LOCATION! Midtown Palace Midtown Palace Midtown Palace 2br Midtown Palace 2br Airy Room on the fa Airy Room on the fa House on 11th - Gar House on 11th - Gar Bergen's Best Short Bergen's Best Short Midtown Palace Suit Midtown Palace Suit ONE OF MANHATTAN ONE OF MANHATTAN Perfect for Parents, Perfect for Parents, CBG Guesthse Rm # CBG Guesthse Rm #1 CommunityBeGood CommunityBeGood CommunityBeGood 7908 4989 1132 8830 7663 9385 1202 7343 7359 7606 1653 7340 6406 5207 property description host_id host_name host_since StreetAdd neighbourhood Stay at Chez Chic buc 2758 Stephanie 976/08 Adam Clayton Powell Jr Blvd, New York, NY 10026, United State Harlem Stay at Chez Chic buc 2758 Stephanie 9/6/08 Adam Clayton Powell Jr Blvd, New York, NY 10026, United State Harlem Midtown Castle 2845 Jennifer 9/9/08 W 38 St, New York, NY 10018, United States Midtown Midtown Castle 2845 Jennifer 9/9/08 W 38 St, New York, NY 10018, United States Midtown Bergen's Best! 5871 Karen 12/31/08 Bergen St, Brooklyn, NY 11213, United States Crown Heights Bergen's Best! 5871 Karen 12/31/08 Bergen St, Brooklyn, NY 11213, United States Crown Heights PERFECT LOCATION! 7118 New-Yorker 1/26/09 10th Avenue, New York, NY 10036, United States Hell's Kitchen Midtown Palace 2845 Jennifer 9/9/08 W 54 Street, New York, NY 10019, United States Hell's Kitchen Midtown Palace 2845 Jennifer 9/9/08 W 54 Street, New York, NY 10019, United States Hell's Kitchen Midtown Palace 2br/ 2845 Jennifer 9/9/08 W 54 Street, New York, NY 10019, United States Hell's Kitchen Midtown Palace 2br/2 2845 Jennifer 9/9/08 W 54 Street, New York, NY 10019, United States Hell's Kitchen Airy Room on the fab 4267 Robin 11/12/08 W 89th St, New York, NY 10024, United States Upper West Side Airy Room on the fab 4267 Robin 11/12/08 W 89th St, New York, NY 10024, United States Upper West Side House on 11th - Gard 11481 Annette 3/26/09 11th St, Brooklyn, NY 11215, United States Gowanus House on 11th - Gard 11481 Annette 3/26/09 11th St, Brooklyn, NY 11215, United States Gowanus Bergen's Best Short St 5871 Karen 12/31/08 Bergen St, Brooklyn, NY 11213, United States Crown Heights Bergen's Best Short St 5871 Karen 12/31/08 Bergen St, Brooklyn, NY 11213, United States Crown Heights Midtown Palace Suite 2845 Jennifer 9/9/08 W 54 Street, New York, NY 10019, United States Hell's Kitchen Midtown Palace Suite 2845 Jennifer 9/9/08 W 54 Street, New York, NY 10019, United States Hell's Kitchen ONE OF MANHATTAN'S 15042 Roberto 4/27/09 West End Ave & W 91st St, New York, NY 10024, United States Upper West Side ONE OF MANHATTAN'S 15042 Roberto 4/27/09 West End Ave & W 91st St, New York, NY 10024, United States Upper West Side Perfect for Parents, V 17571 J. 5/17/09 Carlton Ave, Brooklyn, NY 11205, United States Fort Greene Perfect for Parents, V 17571 J. 5/17/09 Carlton Ave, Brooklyn, NY 11205, United States Fort Greene CBG Guesthse Rm #2. 22486 Communitybe 6/20/09 Park Place, Brooklyn, NY 11217, United States Park Slope CBG Guesthse Rm #2. 22486 Communitybe 6/20/09 Park Place, Brooklyn, NY 11217, United States Park Slope CommunityBeGoodGu 22486 Communitybe 6/20/09 Park Pl, Brooklyn, NY 11217, United States Park Slope CommunityBeGoodGu 22486 Communitybe 6/20/09 Park Pl, Brooklyn, NY 11217, United States Park Slope CommunityBeGood H 22486 Communitybe 6/20/09 Park Pl, Brooklyn, NY 11217, United States Park Slope be accommodates bathrooms bedrooms 2 2 2 2 2 1 2 1 1 1 0 0 2 6 6 2 1 1 3 2 2 1 1 2 1 1 2 5 5 2 1 2 2 city state New York NY New York NY New York NY New York NY Brooklyn NY Brooklyn NY Birmingham AL New York NY New York NY New York NY New York NY New York NY New York NY Brooklyn NY Brooklyn NY Brooklyn NY Brooklyn NY New York NY New York NY New York NY New York NY Brooklyn NY Brooklyn NY Clemson SC Clemson SC Brooklyn NY Brooklyn NY Brooklyn NY 1 zipcode latitude longitude room_type 10026 40.7992048 -73.95367575 Private room 10026 40.7992048 -73.95367575 Private room 10018 40.75362073 -73.98377381 Entire home 10018 40.75362073 -73.98377381 Entire home 11213 40.67437612 -73.93399025 Entire home 11213 40.67437612 -73.93399025 Entire home 10036 40.76260047 -73.99304499 Entire home 10019 40.76530431 -73.98521366 Private room 10020 40.765304310 -73.98521366 Private room 10019 40.76737591 -73.98646702 Entire home 10019 40.767375907 -73.98646702 Entire home 10024 40.79104614 -73.9743446 Private room 10024 40.791046138 -73.97434459 Private room 11215 40.67140381 -73.99232247 Entire home 11215 40.671403814 -73.99232246 Entire home 11213 40.67452195 -73.94109623 Entire home 11213 40.674521946 -73.941096231 Entire home 10019 40.76506179 -73.98638555 Private room 10019 40.765061792 -73.98638555, Private room 10024 40.79300035 -73.97603552 Entire home 10024 40.793000349 -73.97603551 Entire home 11205 40.69168544 -73.97184549 Entire apt 11205 40.691685444 -73.97184549. Entire apt 11217 40.67989493 -73.9779758 Private room 11217 40.679894925 -73.97797579 Private room 11217 40.68000629 -73.97864508 Private room 11217 40.68000629 -73.97864508 Private room 11217 40.680006291 -73.97864508: Private room 2 1 1 1 4 1 4 1 1 6 2 6 2 2 2 2 1 1 1 1 1 1 1 1 1 2 2 1 1 2 1 1 1 3 3 2 2 2 3 3 3 3 3 1 1 1 beds bed_type 2 Real Bed 2 Real Bed 1 Futon 1 Futon 3 Real Bed 3 Real Bed 1 Futon 1 Airbed 1 Airbed 3 Real Bed 3 Real Bed 1 Pull-out Sofa 1 Pull-out Sofa 1 Airbed 1 Airbed 3 Real Bed 3 Real Bed 1 Real Bed 1 Real Bed 1 Futon 1 Futon 1 Airbed 1 Airbed 2 Real Bed 2 Real Bed 1 Pull-out Sofa 1 Pull-out Sofa 1 Pull-out Sofa square_feet price per day guests_included extra_people transaction_amount availability_30 $59.00 2 $40.00 $236.00 $69.00 2 $30.00 $138.00 $250.00 2 $0.00 $1,500.00 $270.00 2 $0.00 $1,350.00 $220.00 6 $50.00 $200.00 $200.00 6 $60.00 $600.00 $180.00 3 $0.00 $180.00 $195.00 2 $0.00 $195.00 $200.00 2 $0.00 $400.00 $475.00 4 $75.00 $475.00 $375.00 4 $55.00 $1,025.00 144 $150.00 1 $25.00 $120.00 144 $120.00 1 $15.00 $240.00 $195.00 2 $26.00 $165.00 $165.00 2 $16.00 $495.00 1300 $240.00 6 $50.00 $200.00 1300 $200.00 6 $30.00 $2,000.00 $255.00 2 $0.00 $225.00 $225.00 2 $0.00 $1,125.00 $175.00 2 $50.00 $155.00 $155.00 2 $40.00 $620.00 $250.00 2 $50.00 $190.00 $190.00 2 $40.00 $190.00 2160 $135.00 2 $30.00 $230.00 2160 $115.00 2 $20.00 $1,150.00 $130.00 2 $30.00 $130.00 $120.00 2 $35.00 $480.00 $135.00 2 $40.00 $405.00 accumulated_host_listing_count 5 4 6 3 5 30 25 29 4 2 2 25 29 1 30 5 4 25 30 25 30 25 transaction_amount availability_30 $236.00 $138.00 $1,500.00 $1,350.00 $200.00 $600.00 $180.00 $195.00 $400.00 $475.00 $1,025.00 $120.00 $240.00 $165.00 $495.00 $200.00 $2,000.00 $225.00 $1,125.00 $155.00 $620.00 $190.00 $190.00 $230.00 $1,150.00 $130.00 $480.00 $405.00 AO U U NN ANN 26 25 26 25 30 25 28 25 25 26 30 25 30 25 30 1 1 2 2 6 5 6 5 5 rating_timestamp 4 4.5 3.5 5 3 4 5 3 3.5 3.5 4.5 2 2 property id transaction date guest_id 2515 1/5/15 G1234 2515 1/5/15 G1234 2515 1/5/15 G1234 2515 3/4/15 G9801 2595 1/7/15 G9817 2595 1/7/15 G9817 2595 1/7/15 G9817 2595 3/10/15 G2234 2595 3/10/15 G2234 4573 1/2/15 G27037 4573 3/15/15 G29674 4989 1/2/15 G35199 5818 1/2/15 G38836 5818 3/17/15 G21994 5862 1/2/15 G21994 5862 3/18/15 G18431 5945 1/2/15 G55475 5945 3/19/15 G72464 6011 1/2/15 G72731 6011 3/21/15 G21994 6103 1/2/15 G92400 6103 3/22/15 G18732 6103 3/22/15 G18732 6177 1/2/15 G99128 6177 3/25/15 G100567 6628 1/2/15 G100800 6628 3/28/15 G103339 GuestRating 1/5/15 1/6/15 1/7/15 3/4/15 1/7/15 1/7/15 1/8/15 3/10/15 3/11/15 1/2/15 3/15/15 1/2/15 1/2/15 3/17/15 1/2/15 3/18/15 1/2/15 3/19/15 1/2/15 3/21/15 1/2/15 3/22/15 3/16/15 1/2/15 3/25/15 1/2/15 3/28/15 5 3 5 4 5 2 1 5 2.5 3 5 2.5 3 4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Environmental Health And Safety Audits A Compendium Of Thoughts And Trends

Authors: Lawrence B. Cahill

2nd Edition

1598889737, 978-1598889734

More Books

Students also viewed these Accounting questions

Question

Describe the major barriers to the use of positive reinforcement.

Answered: 1 week ago