MC1 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, the mutual funds they manage, and securities contained in the mutual funds.

• For each investment company, Investco Scout will keep track of a unique investment company identifier and a unique investment company name as well as the names of multiple locations of the investment company.

• 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.

• Investment companies can manage multiple mutual funds. Investco Scout does not keep track of investment companies that do not mange any mutual funds. A mutual fund is managed by one investment company.

• A mutual fund contains one or many securities. A security can be included in many mutual funds. Investco Scout keeps track of securities that are not included in any mutual funds.

• For each instance of a security included in a mutual fund, Investco Scout keeps track of the amount included.