Name of List: EMPLOYEE

Column Headings:

EmployeeName, DateOfHire, Emploxeephone, EmploxeeAddress, DepartmentName,

DepartmentManager, DepartmentPhone, DepartmentAddress$)$

$\backslash$table$[[\backslash$table$[[$Employee$],[$Name$]],\backslash$table$[[$Dateof$],[$Hire$]],\backslash$table$[[$Employee$],[$Phone$]],$DepartmentName,$\backslash$table$[[$Department$],[$Manager$]],\backslash$table$[[$Department$],[$Phone$]],\backslash$table$[[$Department$],[$Location$]]],[$Sean$,\frac{1}{1}\frac{?}{2012},678-111-1111,$Human Resources,Henry,$770-111-1111,$R$1213],[$Jacob$,\frac{5}{1}\frac{?}{2013},678-222-2222,$Information Systems,John,$770-222-2222,$H$2299],[$Jason$,\frac{9}{1}\frac{?}{2010},678-111-1112,$Operations,Jake,$770-333-3333,$F$1111],[$Henry$,\frac{12}{1}\frac{?}{2011},678-222-2223,$Information Systems,John,$770-222-2222,$H$2299],[$Morgan$,\frac{6}{1}\frac{?}{2008},678-111-1113,$Operations,Jake,$770-333-3333,$F$1111]]$

$1\mathrm{.}1$ For the list provided, indicate the number of themes $($objects$/$items$/$topics$)$ you think the list includes and give an appropriate name for each theme.

There are a total of $4$ themes. They are Employees, Departments, Department Managers, and Department locations

$1\mathrm{.}2$ Show at least one modification problem that will occur when inserting, updating, or deleting data in the given list. Briefly talk about the problem with examples from the given dataset.

$1\mathrm{.}3$ Break up the columns into tables such that each table has a single theme. Specify the primary key for each table. Add ID columns if necessary. Specify the foreign key that will function as a linking column to maintain the relationship between the themes. Give proper names to the final tables.