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:

Direct Labor

The wages or salaries paid to employees who are directly involved in producing goods or providing services.

Electric Power

Electric power is the rate at which electrical energy is transferred by an electric circuit, commonly utilized for domestic, commercial, and industrial activities.

Fixed Costs

Expenses that do not change with the level of goods or services produced over the short term, such as rent or salaries.

Continuous Budgeting

A process of continuously updating the budget by adding a new period as the current period is completed, ensuring the budget always extends a fixed period into the future.