Question: Figure 2-28 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-28 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?

A STOCK Stock ID {Price History (Price, Effective Date)} STOCK Stock ID STOCK PRICE Effective Date Price

A STOCK Stock ID {Price History (Price, Effective Date)} STOCK Stock ID STOCK PRICE Effective Date Price

Step by Step Solution

3.40 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The crux of the answer relies upon what the purpose of the ER diagram is for the modeling situation ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

613-CS-DB (1602).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!