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

Transcribed Image Text:

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 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 manage any mutual funds. A mutual fund is managed by one 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. . A mutual fund contains one or many securities. 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 security included in a mutual fund, Investco Scout keeps track of the amount included. For each investment company, Investco Scout keeps track of how many mutual funds they manage.

Answer rating: 100% (QA)

Creating an Entity Relationship ER diagram based on the given requirements for the Investco Scout Fu View the full answer