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:

Phylogeny

The evolutionary history and the relationships among a species or group of species.

Sympatric Speciation

The evolution of new species from a single ancestral species while inhabiting the same geographical region, without geographic isolation.

Disruptive Selection

A type of natural selection that favors extreme values of a trait over intermediate values, possibly leading to speciation.

Incipient

Relating to the initial stage; just beginning to happen or develop.