PLEASE HELP ON THIS ...SO CONFUSED. Refer to this diagram to answer questions 11

Question

PLEASE HELP ON THIS ...SO CONFUSED.

Refer to this diagram to answer questions 11 through 20.

Refer to this diagram to answer questions 11 through 20.

MC Qu. 19 Which of the following is true to implement the ...

Which of the following is true to implement the Buy/Sell Transactions and Brokers classes and the association between them in the preceding UML class diagram in a database?

Multiple Choice

The primary key of Brokers is a foreign key in Buy/Sell Transactions.

The primary key of Buy/Sell Transactions is a foreign key in Brokers.

The association between Brokers and Buy/Sell Transactions is implemented as a linking table.

Both "The primary key of Brokers is a foreign key in Buy/Sell Transactions" and "The primary key of Buy/Sell Transactions is a foreign key in Brokers" are true.

None of these is true.

Explanation / Answer

The correct answer is

a) The primary key of Brokers is a foreign key in Buy/Sell Transactions.

Because the relationship says , 1 broker can have 0 or many buy/sell transactions, so for each but sell transaction there will be 1 broker. So we can place broker id in a column of Buy/Sell Transaction which will be a foreign key

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.