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:

Relationships

Connections or associations between two or more people, characterized by emotional or social bonds, reciprocal effects, and interactions.

Hormone Levels

The concentrations of hormones present in the bloodstream, indicating various biological conditions.

Sexual Motivation

The drive or desire to engage in sexual activities, influenced by biological, psychological, and socio-cultural factors.

Neuroscience

Neuroscience is the scientific study of the nervous system, encompassing aspects of biology, psychology, and medicine to understand the brain and behavior.