Given the following business rules:

A department has many employees.

An employee works for one department.

An employee may supervise many employees.

An employee may be supervised by one employee.

An employee may have many dependents.

A dependent relates to one employee.

An employee may work on many projects.

A project is worked on by many employees.

A project belongs to a department.

A department may have many projects.

A department is managed by one employee.

An employee may manage only one department.

A department may be in several locations.

A location relates to one department.

Given that information, create the complete ERD $($using correct connection symbols for relations$)$ containing all primary keys, foreign keys, and main attributes.

Create a database for the above ERD and populate the database with at least $10$ records for each entity. Each bridge entity must have at least $15$ entries.

Submit your ERD and script file for populating database.