Critical Thinking Questions Case 1 Mary Has Been Asked to Create

question 65

Essay

Critical Thinking Questions Case 1 Mary has been asked to create a database for her company. The database is to track employees and the departments for which the employees work. A department can have between 5 and 15 employees. She has determined that she needs the following tables: Employee (Social Security Number, Employee Name, Street Address, City, State, Postal Code, Date Hired, Salary, Department Code)Department (Department Code, Department Name)Which field in the Employee table should be the primary key and why?

---

Definitions:

Approximate Height

A measurement that provides an educated guess or estimation of an object or person's height, not necessarily based on precise measurements.

Gross Profit Margin

A financial metric indicating the percentage of revenue that exceeds the cost of goods sold; it measures a company’s production efficiency.

Sales Revenue

The income received by a company from its sales of goods or the provision of services.

Product Costs

The total costs directly tied to the creation of a product, including raw materials, labor, and overhead expenses.