Question: Figure 2-27 shows two diagrams (A and B), both of which are legitimate ways to represent that a stock has a history of many prices.
Figure 2-27 shows two diagrams (A and B), both of which are legitimate ways to represent that a stock has a history of many prices. Which of the two diagrams do you consider a better way to model this situation and why?

STOCK Stock ID {Price History (Price, Effective Date)} STOCK Stock ID STOCK PRICE Effective Date Price
Step by Step Solution
3.48 Rating (158 Votes )
There are 3 Steps involved in it
The crux of the answer relies upon what the purpose of the ER diagram is for the modeling situation ... View full answer
Get step-by-step solutions from verified subject matter experts
