This illustration shows the database schema for the HR application. Every table has a system-defined Id field. The Location table has one user-defined field, Name. The Department table has two user-defined fields, Name and Location. The Employee table has four user-defined fields: Name, Department, Hire Date, and Email. A Location can have any number of Departments. A Department can have zero or one Location. A Department can have any number of Employees. An Employee can have zero or one Department.