2. (50 points) [Research: ternary relationship] Consider the Trade relationship shown below. (This relationship was discussed...

 

Transcribed Image Text:

2. (50 points) [Research: ternary relationship] Consider the Trade relationship shown below. (This relationship was discussed in class.) Some ER schema design tools support only binary relationships, and in that case we should represent the ternary relationship using binary relationships instead. With this regard, read the textbook Section 3.9.1, including Figure 3.17, and do the exercises a and b below. M N Buyer Trade Seller K Broker (a) Draw an ER schema diagram with three binary relationships in the same manner as in Figure 3.17b, and explain why the three binary relationships together (i.e., in conjunction) are not equivalent to the ternary relationship Trade. (b) Draw an ER schema diagram with three binary relationships in the same manner as in Figure 3.17c, and explain why the three binary relationships together (i.e., in conjunction) are equivalent to the ternary relationship Trade. 2. (50 points) [Research: ternary relationship] Consider the Trade relationship shown below. (This relationship was discussed in class.) Some ER schema design tools support only binary relationships, and in that case we should represent the ternary relationship using binary relationships instead. With this regard, read the textbook Section 3.9.1, including Figure 3.17, and do the exercises a and b below. M N Buyer Trade Seller K Broker (a) Draw an ER schema diagram with three binary relationships in the same manner as in Figure 3.17b, and explain why the three binary relationships together (i.e., in conjunction) are not equivalent to the ternary relationship Trade. (b) Draw an ER schema diagram with three binary relationships in the same manner as in Figure 3.17c, and explain why the three binary relationships together (i.e., in conjunction) are equivalent to the ternary relationship Trade.