After creating the tables and relationships for the Antiques database, you meet with Tim Richards,..

After creating the tables and relationships for the Antiques
database, you meet with Tim Richards, the chief information officer for the NHD
Development Group, and Linda Sutherland, the manager of the antique mall. As
you review the database, Linda makes a few requests. When she tracked sales for
a month, she found that repeat customers accounted for 60% of her revenue. She
therefore wants to use the Antiques database to increase marketing efforts to
her current customer base. First, she wants to extract information about her
customers, such as a list that organizes customers by city and
»

After creating the tables and relationships for the Antiques
database, you meet with Tim Richards, the chief information officer for the NHD
Development Group, and Linda Sutherland, the manager of the antique mall. As
you review the database, Linda makes a few requests. When she tracked sales for
a month, she found that repeat customers accounted for 60% of her revenue. She
therefore wants to use the Antiques database to increase marketing efforts to
her current customer base. First, she wants to extract information about her
customers, such as a list that organizes customers by city and another that
provides customer names and phone numbers. She also needs to retrieve information
about the antique and restoration classes the mall offers to determine which
customers enroll in the classes. Then she could provide information in the
classes about items that might interest those customers. She asks for your help
filtering data and creating queries that extract the information she needs.

Complete the following:

Linda is planning to create a brochure for the mall, and
wants to highlight the number of booths within the mall. She wants to advertise
that the mall has fifteen 8 × 8 booths, five 12 × 10 booths, and so on. Because
Linda has recently reworked the booth divisions and expects to make additional
changes in the future, she wants to list how many booths of each size the mall
currently has. Name the query qryBoothSize.

»