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