Create an EDR using Microsoft Access:

The company is organized into departments. Each department has a unique number, name and a number of employees. One of the employees is the manager of the department. The company keeps track of the date each department's manager was appointed.

Each department controls a number of projects. Each project has a unique number, name and is located at a single location and controlled by only one department.

The company stores each employee's ID_number, address, salary, sex, and Date_of_birth. Each employee works for one department but may work on several projects although some employees do not work on any project. The company records the date an employee starts to work on a project and the date she stops working on that projects.

Each employee may have a number of dependants but a dependant is associated with only one employee. For each dependant, the company records their name, sex, Date_of_birth, and relationship to employee.