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

question 39

Essay

You have a database containing customer information, including orders, for a small retail store where you work. 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:

Joint Decision Making

A collaborative process where two or more individuals or parties come together to make a decision based on shared understandings and consideration of all viewpoints.

Collaboration

The action of working together with others efficiently and effectively to achieve a common goal or complete a task.

Empowering Leadership

A leadership approach that aims to give employees more autonomy, authority, and encouragement to make decisions and contribute ideas.

Psychological Empowerment

The perception of having the control, competence, meaningfulness, and impact in one’s work role.