Question: can please anyone help me with this assignment for the database Answer each of the following questions using the Solmaris Condominium Group data shown in
can please anyone help me with this assignment for the database
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 owners 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 owners 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?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
