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:

Regression Equation

An equation that represents the relationship determined by regression analysis, predicting the dependent variable based on independent variables.

Dummy Variable

A variable used in regression analysis that assumes the value 0 or 1 to indicate the absence or presence of some categorical effect.

Independent Variable

A variable that is manipulated to determine its effect on a dependent variable within an experimental study.

3-ethyl-3-methylhexane

A branched alkane with the formula C8H18, having an ethyl and a methyl group on the third carbon of the hexane chain.