* = primary key
@ = foreign key
^ = unique value
department(departmentId*, departmentName, departmentLocation, departmentManager(employee.employeeId)@)
project(projectId*, departmentId@, projectName, projectBudget)
employee(employeeId*, firstName, lastName, SSN, employeeAddress, phone, employeeSalary, employeeDOB, departmentId@, employeeSupervisor(employee.employeeId)@)
employeeshift(employeeshiftId^, employeeId*, shift*) shift = enum(Mon,Tue,Wed,..)
employeedependent(employeedependentId*, employeeId@, name, DOB, relationship)
employeespouse(employeeId*@, name, DOB)
employee_project(employeeId*@, projectId*@, startDate)

customer()
product()