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:

Meeting

A gathering of two or more people convened for the purpose of achieving a common goal through discussion, sharing information, or making decisions.

Work

An activity involving mental or physical effort done in order to achieve a purpose or result, often associated with a profession or occupation.

Late

describes being after the expected, regular, or usual time or the state of delayed timing.

Excuse Game

A behavioral pattern where individuals routinely justify their actions or decisions with excuses, often to avoid responsibility.