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:

Transported

Refers to materials that have been moved from their original location to a new place by natural processes such as erosion or glaciation.

Metamorphic Rock

A type of rock formed through the alteration of pre-existing rocks in response to high heat, pressure, and chemically active fluids.

Deposition

The process by which sediments, soil, and rocks are added to a landform or land mass, often through the action of wind, ice, and water.

Uplift

The process of the Earth's surface rising due to natural geological processes, such as tectonic plate movements.