Critical Thinking Questions Case 1-1 Joe Has Been Asked to Create

question 23

Essay

Critical Thinking Questions 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:

Inventory Purchase

The acquisition of goods and materials that a company holds for the purpose of resale or production.

Perpetual Inventory System

An accounting method that records inventory purchases and sales in real-time, providing a constant update of inventory levels.

FOB Shipping Point

is a term used in shipping, where the buyer becomes responsible for goods once they are shipped, and must pay for the transport costs.

Credit Memo

A document issued by a seller to a buyer, reducing the amount the buyer owes to the seller under previous transactions, often due to a return or refund.