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?

Question

Quizplus · Accepted Answer

The Answer of 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?

Critical Thinking Questions Case 1 Mary Has Been Asked to Create