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:

Affected By

Influenced or changed by something; the state of being impacted by external factors or conditions.

Implement

To put into action or execute a plan, decision, or tool, especially in a practical context.

Staff Planners

Individuals responsible for developing, organizing, and managing staff schedules, resources, and future personnel needs.

Communication Gap

A barrier or misunderstanding that occurs during the exchange of information between individuals or groups.