You are now looking at information for a financial management institution. They have a variety of funds. Each fund can have multiple types of investments (Common stock, municipal bonds, growth stock, etc.). Each fund could have several different managers. However managers only handle one type of investment. All investments of a given type in a fund are handled by the same manager.
FMI
|
Fund Id
|
Investment Type
|
Manager
|
|
104
|
Common Stock
|
Black
|
|
104
|
Municipal Bonds
|
Jones
|
|
296
|
Preferred Stock
|
Smith
|
|
296
|
Common Stock
|
Black
|
|
010
|
Common Stock
|
Green
|
|
999
|
Municipal Bonds
|
Grey
|
Explain the issues that exist between 3NF and BCNF. Now normalize through BCNF. Show the relations at each step even if there is no change so I can see the process.