Verify You Have Extracted the Correct Data :Increasing Real Estate Management Profits: Harnessing Data Analytics (Excel to MySQL: Analytic Techniques for Business Specialization) Answers 2025

1

1. How many tables are there in the Watershed database?
   ✔ 6
   ❌ 2
   ❌ 4
   ❌ 8

2. How many fields, or columns, are there in the property_type table?
   ✔ 4
   ❌ 7
   ❌ 6
   ❌ 5

3. Which of the following things are true about Watershed property W106?
   ✔ It’s a 2-bedroom apartment in Austin, TX
   ❌ It’s a 1-bedroom house in San Francisco, CA
   ❌ It’s a 1-bedroom apartment in Miami, FL
   ❌ It’s a 2-bedroom house in Chapel Hill, NC

4. Which of the following things are true about the example short-term rental property that has the same type and is found in the same location as Watershed Property W24?
   ✔ The nightly rental price is $239 and its occupancy rate in 2015 was 67.7%
   ❌ $283 / 49.9%
   ❌ $180 / 71.5%
   ❌ $220 / 40.3%

5. How many of the client’s 244 Watershed properties have kitchens?
   ✔ 238
   ❌ 0
   ❌ 244
   ❌ 104

Summary Table