can please anyone help me with this assignment for the database Answer each of t

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 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?

Explanation / Answer

1)

Owner Number Last Name First Name

AD057 Adney Bruce and JeanAN

AN175 Anderson Bill

BL720 Blake Jack

EL025 Elend Bill and Sandy

FE182 Feenstra Daniel

JU092 Juarez Maria

KE122 Kelly Alyssa

NO225 Norton Peter and Caitlin

RO123 Robinson Make and Cathy

SM072 Smeltz Jim and Cathy

TR222 Trent Michael

WS032 Wilson Henry and Karen

2 )

3 )

Last Name First Name Address City State Zip

Adney Bruce and Jean 100 Ocean Ave. Bowton FL 31313

Elend Bill and Sandy 100 Ocean Ave. Bowton FL 31313

4 )

Last Name First Name City

Anderson Bill Brunswick

Robinson Mike and Jane Springs

This is against chegg policy to post multiple questions in a single post, i have done 4 parts kindly post other parts accordingly.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.