This illustration shows the database schema for the HR application. The Department table has three fields: Name, Location, and Manager. The Employee table has six fields: Name, Email, Hire_Date, Department, Address, and Job. An Employee can have zero or one Departments and can have one manager. A Department and a Manager can have any number of Employees.