What Fields Would You Want to Include in a Table

question 85

Essay

What fields would you want to include in a table that keeps track of personal addresses? Using CamelCase notation,what would you name each field? What data type would you use for each of the fields in the table? What data type would you assign to the Zip field? Why?

---

Definitions:

Nonlabor Income

Income received from sources other than employment, such as investments, pensions, or gifts.

Wage Rate

The amount of money that an employee is paid per unit of time, such as an hour, often analyzed in labor economics.

Labor Income

Earnings derived from employment, including wages, salaries, bonuses, and other compensation for work performed.

Lump Sum Payment

A single payment made at a particular time, as opposed to a series of payments made over time.