Draw an ERD for Wolf INC. Wolf INC is an IT firm with approximately 400 employees. Wolf INC needs a database to keep track of employees, projects assigned, departments, and employee skills. Employees have a unique employee number, a name, address, and date of birth. If the employee is married to another employee at the company the date of marriage is collected. Each employee is given a job title (e.g., software engineer, SQL programmer, and so on). An employee does only one type of job at any given time, but the employee can have several previous job titles. We need to retain information for an employees current job but also maintain information about previous titles. Each job title is assigned a number, and a short description.

There are nine departments, each with a unique ID and name. An employee can report to only one departmentand a department has many employees. A department could possibly not have any employees. Each department has a phone number and location.

To acquire various kinds of supplies, each department deals with many vendors. A vendor supplies equipment to many departments. Wolf INC stores the name and address of each vendor and the date of the last meeting between a department and a vendor.

Many employees can work on a project however, an employee does not have to be assigned to a project. A project must have at least one employee to exist. An employee can work on many projects. A project is located in a single city. For each city, Wolf INC is interested in its state and population. Project numbers distinguishes projects, and we must store the estimated cost of each project.

Paste screenshot of your ERD here