1. Extract Entity Types and Identify Relationship Matrix Based on the given Investment Portfolio Scenario in Section 3.1, four external entity types have been extracted. They are identified as: Client, Stock, Mutual Fund and Family Fund Client Stock Mutual Fund Family Fund Client Stock Mutual Fund Family Fund

2. Generated Business rules: The three pairs of relationships are further defined as the database business rules as follows: One client may invest in one or more than one stock. A stock may be bought by one or more than one client. One client may invest in one or more than one mutual fund. A mutual fund may be bought by one or more than one client. One fund family must have one or more than one mutual fund. One fund must belong to only one fund family.

3. Draw an ER diagram with 1) entity types, 2) relationship types, 3) keys, 4) cardinality and 5) PKs and FKs Database Logical Design

4. Map the ER diagram to a relational database schema indicating the relation name, primary key and foreign key. Add appropriate additional attribute.

5. Establish join paths for the above relational database using the referential integrity by drawing arrow lines between the above tables. Indicate all the foreign keys (FK). F.K. -> P.K.

6. Do functional analysis for each of your tables Attribute A -> Attribute B (Determinant attribute(s) Determines Dependent Attribute(s))

7. Show all the normalized tables and indicate the normalization form for each of your tables. Table Name 1NF 2NF 3NF