Assignment Content

For this assignment you will be using Online Visual Paradigm. You should have received an email about VPO sometime last week.

Please activate your license using your OLLU email address. Do not use another email address or you will not get the free

license.

This is a modeling CASE tool that will allow you to practice creating ER models. Learning how to use CASE tools is an important skill

in our field and this assignment will give you the chance to practice. You will receive $($or have received$)$ an email from Online Visual

Paradigm with instructions on how to access the free educational license. If you cannot find the email or would like the email to be

resent please contact your instructor. You must use your OLLU student email in order to receive the full educational version of the

software. This software is web$-$based and can be used with all operating systems.

Explanation of the problem: Investco Scout is an investment research company $.$ Create the ER diagram and a class

diagram for the Investco Scout Funds Database, based on the following requirements:

a$.$ The Investco Scout Funds Database will keep track of investment companies, the mutual funds they manage, and

securities contained in the mutual funds.

b$.$ 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.

c$.$ 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.

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

e$.$ 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.

f$.$ 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.

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

Solve the problem: Create requirements and the ER diagram for the scenario above with two entities $($both with several

attributes$)$ involved in the following relationships. Please make sure you have read all content in this module before you

begin this assignment.

a$.1$:M relationship, where participation on the $1$ side is mandatory and participation on the $M$ side is optional.

b$.1$:M relationship, where participation on the $1$ side is optional and participation on the $M$ side is mandatory.

c$.1$:M relationship, where participation on both sides is mandatory.

d$.1$:M relationship, where participation on both sides is optional.

e$.$ M:N relationship, where participation on one side is mandatory and participation on the other side is optional.

f$.$ Create an example of an entity with a composite attribute.

g$.$ Create an example of an entity with a composite unique attribute.

h$.$ Create an example of an entity with candidate keys $($multiple unique attributes$).$

i$.$ Create an example of an entity with a multivalued attribute.

j$.$ Create an example of an entity with a derived attribute.

k$.$ Create an example of an entity with an optional attribute