Joe Has Been Asked to Create a Special Projects Database

question 46

Short Answer

Joe has been asked to create a Special Projects database for his sampany. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. He has determined that he needs the following tables: Employee (Social Security Number, Last Name, First Name, Street Address, City, State, Postal sade, Hourly Pay Rate, Project sade) Project (Project sade, Project Name, Total Hours, sampletion Date) Which field in the Employee table should be the primary key and why?

---

Definitions:

Wage Rate

The standard amount of pay given to workers per unit of time, often expressed per hour or year.

Labor Supply Curve

Represents the relationship between the quantity of labor that workers are willing to offer and the wage rate, typically showing an upward slope indicating more labor supplied as wages increase.

Wage Rate

The fixed amount of compensation paid to an employee by an employer in exchange for work performed.

Supply Curve

A visual chart that illustrates the correlation between a product's price and the amount that producers are prepared to offer for sale.