Phil Has Been Asked to Create a Database for His

question 26

Short Answer

Phil has been asked to create a database for his company.The database is to track employees and the projects on which the employees work.A project can have between 3 and 7 employees assigned to it.He has determined that he needs the following tables: Employee (Social Security Number, Employee Name, Street Address, City, State, Postal                   Code, Date Hired, Hourly Pay Rate, Project Code)Project (Project Code, Project Name, Completion Date)Which field in the Employee table should be the primary key and why?

---

Definitions:

Residents of Enemy Country

Individuals residing in a nation that is in a state of conflict or war with another country, often subjected to certain legal restrictions.

Legal Sense

Pertains to understanding, reasoning, or interpretation within the framework of law.

Insanity

A legal term for mental illness of such a severe nature that a person cannot distinguish fantasy from reality, cannot conduct her/his affairs due to psychosis, or is subject to uncontrollable impulsive behavior.

Charter of Rights and Freedoms

A foundational document in Canadian law that guarantees fundamental freedoms and rights to citizens and residents of Canada.