Question

Stock Exchanges Brokers 1 6 1..1 2 5 0 1..1 0.." Buy/Sell Stocks Transactions 3 4

1. Which of the following best describes the meaning of the multiplicities next to the number 1 in the preceding diagram?

1. Stocks are traded in only one exchange.
2. Stocks are traded in at least one exchange.
3. Stocks are traded in a minimum of zero exchanges.
4. Stocks are traded in a maximum of many exchanges.
5. Both c and d are correct.

2. Which of the following best describes the meaning of the multiplicities next to the number 2 in the preceding diagram?

1. Each exchange trades at least one stock.
2. Each exchange trades only one stock.
3. Each exchange trades a minimum of zero stocks.
4. Each exchange trades a maximum of many stocks.
5. Both a and d are correct.

3. Which of the following is true to implement the Stock Exchanges and Stocks classes and the association between them in the preceding UML class diagram in a database?

1. The primary key of Stocks is a foreign key in Stock Exchanges.
2. The primary key of Stock Exchanges is a foreign key in Stocks.
3. The association between Stocks and Stock Exchanges is implemented as a linking table.
4. Both a and b are true.
5. None of these is true

4. Which of the following best describes the meaning of the multiplicities next to the number 3 in the preceding diagram? LO 3-2, LO 3-3

1. Each transaction involves at least one stock.
2. Each transaction involves only one stock.
3. Each transaction involves a minimum of zero stocks.
4. Each transaction involves a maximum of many stocks.
5. Both a and b are correct.

5. Which of the following best describes the meaning of the multiplicities next to the number 4 in the preceding diagram?

1. Each stock is bought/sold at least once.
2. Each stock is bought/sold only once.
3. Each stock is bought/sold a maximum of many times.
4. Each stock is bought/sold a minimum of many times.
5. Both a and c are correct.

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

1. The primary key of Stocks is a foreign key in Buy/Sell Transactions.
2. The primary key of Buy/Sell Transactions is a foreign key in Stocks.
3. The association between Stocks and Buy/Sell Transactions is implemented as a linking table.
4. Both a and b are true.
5. None of these is true.

7. Which of the following best describes the meaning of the multiplicities next to the number 5 in the preceding diagram?

1. Each Broker is involved in one Buy/Sell Transaction.
2. Each Broker is involved in many Buy/Sell Transactions.
3. Each Broker is involved in a minimum of one Buy/Sell Transaction.
4. Each Broker is involved in a minimum of zero Buy/Sell Transactions.
5. Both b and d are correct.

8. Which of the following best describes the meaning of the multiplicities next to the number 6 in the preceding diagram?

1. Each Buy/Sell Transaction involves one Broker.
2. Each Buy/Sell Transaction involves many Brokers.
3. Each Buy/Sell Transaction involves a minimum of zero Brokers.
4. Each Buy/Sell Transaction involves a maximum of many Brokers.
5. Both a and d are correct.

9. 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?

1. The primary key of Brokers is a foreign key in Buy/Sell Transactions.
2. The primary key of Buy/Sell Transactions is a foreign key in Brokers.
3. The association between Brokers and Buy/Sell Transactions is implemented as a linking table.
4. Both a and b are true.
5. None of these is true.

10. Which of the following is true to implement the Stock Exchanges and Brokers classes in the preceding UML class diagram in a database?

1. The primary key of Brokers is a foreign key in Stock Exchanges.
2. The primary key of Stock Exchanges is a foreign key in Brokers.
3. The association between Brokers and Stock Exchanges is implemented as a linking table.
4. Both a and b are true.
5. None of these is true.

Answer 1

1. Both c and d are correct.

A stock can trade on any exchange on which it is listed. And to be listed it must meet all of the exchange's listing requirements.A company can list its shares on more than one exchange, which is referred to as dual listing - although few companies do.

2. Each exchange trades at least one stock.

4. Each transaction involves only one stock.

5. Both a and c are correct.

7. Both b and d are correct.

8.Both a and d are correct.

3, 6, 9 & 10 Can't answer as the UML class diagram is not shared.