Case 1-1 Joe Has Been Asked to Create a Special Projects Database

question 110

Essay

Case 1-1
Joe has been asked to create a Special Projects database for his company.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 Code,Hourly Pay Rate,Project Code)
Project (Project Code,Project Name,Total Hours,Completion Date)
-Which field in the Project table should be the primary key and why?

---

Definitions:

Stereotype

A common, yet rigid and simplified perception or conception of a specific kind of individual or object, usually formed from insufficient data.

Hiring

The process of reviewing applications, interviewing candidates, and selecting an individual for employment.

Promotion

The advancement of an employee to a higher job position or rank within the organization, often accompanied by increased responsibilities and salary.

Norm of Reciprocity

A social rule suggesting that people should repay, in kind, what another person has provided for them; this is the basis for the exchange of goods, services, and acts of kindness.