Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Investco Scout is an investment research company. Create the ER diagram for the Investco Scout Funds Database, based on the following requirements. The Investco
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.
Step by Step Solution
★★★★★
3.40 Rating (141 Votes )
There are 3 Steps involved in it
Step: 1
Creating an EntityRelationship ER diagram based on the given requirements for the Investco Scout Funds Database we can represent the following entitie...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started