Answer to Problem 2.4

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.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License