Investco Scout is an investment research company. Create the ER diagram for the Investco Scout Funds...
Fantastic news! We've Found the answer you've been seeking!
Question:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
Creating an EntityRelationship ER diagram based on the given requirements for the Investco Scout Funds Database we can represent the following entitie... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
How do I view vector and bitmap images in a VR headset?
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
Snooty Fashions is an exclusive fashion designer business. Snooty Fashions collaborates with several fashion designers to design outfits. For every fashion designer, a unique ID, name, city of...
-
Titanium metal requires a photon with a minimum energy of 6.94 10 - 19 J to emit electrons. (a) What is the minimum frequency of light necessary to emit electrons from titanium via the photoelectric...
-
A heat exchanger is used to cool an air flow from 800 to 360K, both states at 1 MPa. The coolant is a water flow at 15C, 0.1 MPa. If the water leaves as saturated vapor, find the ratio of the...
-
You are in the final year of your apprenticeship, working in a material testing laboratory. Your line manager has asked you to put together a booklet explaining materials, and their properties to the...
-
Dave Parrett, sales manager for Ace Chemicals, is wrestling with the issue of how to get Kay Powers back on track. Kay has been with the company for 20 years. Historically, she had been one of the...
-
The consumption function captures one of the key relationships in economics that was first developed by John Maynard Keynes. It expresses consumption as a function of disposable income, where...
-
Insight Bank has a $ 14 million position in a ten-year, zero-coupon bond with a face value of $17 000 000. The bond is trading at a yield to maturity of 6.7 per cent. The historical mean change in...
-
Mendina, Incorporated produces an advanced type of coffee maker. Information about the coffee maker is below: Total Variable Cost at 200 units Total Cost per Unit Sales Price Target Profit Volume...
-
A universal joint (coupling) is considered a positive, mechanical connection between nonparallel rotating shafts. Explain the problem causing nonuniformity of motion transmission through this type of...
-
Explain the terms supply chain and logistics.
-
Jean Kelley owned three limited partnership interests in 2018: How much is her passive loss deduction (against nonpassive activities) and suspended loss for each activity? 2018 Allocated Date Gain/...
-
Describe some of the obstacles to lean success.
-
Evaluate the studies which aim to establish the link between SHRM and organisational performance.
-
Analyse the relationship between organisational structure and SHRM.
-
Smallest change which a sensor can detect is O Accuracy Threshold Span Resolution
-
Illini Company, Inc. Balance Sheet as of 12/31/20X0 Assets Current Assets: Cash $1,500,000 Accounts receivable, net 18,000 Inventory 50,000 Total current assets 1,568,000 Equipment 90,000 Goodwill...
-
For your answers to Problem and Exercise 3-33 from Chapter 3, transform the EER diagrams into a set of relational schemas, diagram the functional dependencies, and convert all the relations to third...
-
Why are field values sometimes coded?
-
What are four reasons why data quality is important to an organization?
-
Family Supermarkets (FS) has decided to increase the size of its Memphis store. It wants information about the profitability of individual product lines: soft drinks, fresh produce, and packaged...
-
How do managers refine a costing system?
-
When does product undercosting or overcosting occur?
Study smarter with the SolutionInn App