Investco Scout

Investco Scout is an investment research company. Create the ER diagram for the Investco Scout Funds Database, based on the following requirements.

The Investco Scout Funds Database will keep track of investment companies, their locations, the mutual funds they manage, and securities contained in the mutual funds.

Tables:

For each investment company, Investco Scout will keep track of a unique investment company identifier and a company name.

For each location, Investco Scout will keep track of a unique location identifier, name of the location, ZIP code and State.

For each mutual fund, Investco Scout will keep track of a unique mutual fund identifier as well as the mutual fund name and inception date.

For each security, Investco Scout will keep track of a unique security identifier as well as the security name and type.

Relationships:

In each location, there could be multiple investment companies, and each company can operate in multiple locations.

Investment companies can manage multiple mutual funds. A mutual fund is managed by one investment company.

A mutual fund contains many securities. A security can be included in many mutual funds.

Question: Draw an ER database diagram for each case using Excel, or Words shapes.