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:

Organizational Goals

The objectives or targets that an organization aims to achieve within a specified timeframe, guiding its strategic and operational activities.

Attraction-Selection-Attrition Theory

A theory that suggests organizations develop unique cultures by attracting, selecting, and retaining individuals whose personalities fit well with the current organizational culture.

Organizational Culture

Is the set of shared attitudes, values, goals, and practices that characterizes an institution or organization.

Ethical Conduct

Adhering to a set of moral principles or values in decision-making and actions.