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:

Brainwashing

The process of forcibly altering an individual's beliefs, attitudes, and perceptions through coercive means.

Self-concept

An individual's perception of themselves, including beliefs about their own abilities, characteristics, and behaviors.

Innate Experiences

Experiences that are considered to be natural, intrinsic, or inherent from birth, not influenced by external factors.

Worldviews

The basic mental framework of a person or society that includes all of their knowledge and perspective.