You Have a Database Containing Customer Information, Including Orders, for a Small

question 45

Essay

You have a database containing customer information, including orders, for a small retail store you work at. The database is relational and the database designer organized the tables so that the columns contain only single pieces of information. For example, the names of customers take up to three fields (First, Middle, and Last Name). Naming conventions in the database use uppercase characters for each word in a field name.
Describe how you can create a report that lists the Names of customers and their phone numbers, grouped by the City in which they live.

---

Definitions:

Subscription-based Plans

Subscription-based plans are payment models where users pay a recurring fee, usually monthly or annually, to access a product or service.

Robust Communications

Communications systems or methods that are reliable, error-resistant, and capable of operating under varying conditions.

Skype

A telecommunications application that provides video chat and voice call services, allowing users to communicate over the internet.

High-definition Videoconferencing

A method of conducting meetings or conversations remotely with high-resolution video quality.