Answer each of the following questions using the Solmaris Condominium Group data shown in Figures 1-21 through 1-25. No computer work is required.
1. List the owner number, last name, and first name of every condominium owner.
2. List the condo ID number for each condo that is larger than 1,200 square feet.
3. List the last name, first name, and street address of every owner located in Bowton.
4. List the last name, first name, and city of every owner who owns more than one condo.
5. List the last name, first name, and city of every owner with a condo that has a condo fee of less than $200 per month.
6. List the unit number of each condo at the Solmaris Bayside location.
7. List the owner€™s last and first names and the unit number for each condo that has a scheduled or open service request.
8. List the location number, unit number, and owner number for each condo that has two or more scheduled or open service requests.
9. List the condo ID number and square footage for each condo that has a painting service request.
10. List the condo ID number and the owner€™s last and first names for each condo that has a carpentry service request.
11. The Solmaris database does not include a field for service fees. In which table would you place the information for service fees? Why?
12. Each condo location has a location supervisor. In which table would you place the information about the location supervisor?

Figure 1-21

Transcribed Image Text:

Location Address 100 Ocean Ave. 2 Solmaris Bayside 405 Bayside Blvd. Glander Bay LocationNum LocationName State PostalCode City Bowton 1 Solmaris Ocean FL 31313 31044 FL