Critical Thinking Questions Case 1 Mary Has Been Asked to Create

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?