You Have a Database That Contains Information About All of the Employees

question 7

Essay

You have a database that contains information about all of the employees from your company.  There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID.
Your supervisor wants to see a list of employees who are making over $25,000.00 and have a last name of a "Wilson". Describe how to accomplish this.

---

Definitions:

Engagement

Engagement is a formal agreement between two people to get married, or the period between the proposal and the wedding.

Future In-Laws

The parents of one's fiancé(e) or the parents of one's child's spouse, who are likely to become part of one's extended family through marriage.

Better Acquainted

The process of getting to know someone or something more thoroughly.

Passive-Congenial Marriage

The partners have little emotional investment in the marriage and few expectations of each other.