It's also the case that Dividend is dependent on Stock, Name on Cust ID, and Addr on Cust ID. These changes, combined with the changes discussed just above, give us the following two new relational relations:
- Cust ID —> [Name, Addr]
- Stock —> [Curr Price, Dividend]
The original schema has now been reduced to
[Cust ID, Stock] —> Shares
since Name, Addr, Curr Price, and Dividend were all removed and put into the new schemas.
Return to 2nd normal form discussion.