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:

Deficit Needs

A concept in Maslow's hierarchy of needs that refers to the basic requirements for physical and psychological well-being, such as food, safety, and belonging.

Declining Percentage

A decrease in the proportion or ratio of a quantity relative to a whole or to other relevant quantities over a specified period.

Self-Actualization Theory

A concept in humanistic psychology that represents the realization of a person's potential, self-fulfillment, seeking personal growth and peak experiences.

Rigorous

Marked by a high level of strictness or severity, often in the context of academic standards, research methodology, or physical training.