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:

Real Assets

Real assets refer to physical or tangible assets such as land, buildings, gold, or commodities, which have intrinsic value.

Interest-Bearing Assets

Interest-bearing assets are financial assets that earn interest over time, such as savings accounts, bonds, or loans given to others.

Flexibility Option

An option that provides the holder with the ability to adapt or change an investment based on changing circumstances.

Inputs/Outputs

In economics and business, inputs refer to the resources used in the production process, while outputs are the goods or services produced.