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:

Loss-Minimizing

A strategy or approach aimed at reducing losses to the lowest possible level under adverse conditions.

Total Revenue

The cumulative income produced from the primary business operations of a company, manifesting from goods or service sales.

Total Cost

The sum of all expenses incurred in the production of goods or services, including fixed and variable costs.

Profit-Maximizing

The process or strategy undertaken by a company to increase its profits to the highest possible level.