Case 1-1 Joe Has Been Asked to Create a Special Projects Database

question 103

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 Employee table should be the primary key and why?

---

Definitions:

Subsidiary Ledger

A secondary ledger that provides detailed information to support accounts listed in the general ledger, such as customer or vendor details.

Revenue Journal

An accounting ledger that records incoming revenue transactions or sales made by a company.

General Ledger

A complete ledger detailing every fiscal activity during the lifespan of a business.

Transaction Errors

Mistakes or inaccuracies occurring in the recording, processing, or reporting of financial transactions.