ACCT 460 Chapt 3 Multiple Choice Questions
Which of the following is true to implement the Buy Sell Transaction san dBrokers classes and the association between them in the preceding UML class diagram in a database? a. The primary key of Brokers is a foreign key in Buy Sell Transactions b. The primary key of Buy Sell Transactions is a foreign key in Brokers c. The association between Brokers and Buy Sell Transactions is implemented as a linking table. d. Both a and b are true e. None are true
a. The primary key of Brokers is a foreign key in Buy Sell Transactions
Which one of the following best describes the meaning of this UML class diagram? New car inventory 1..1 0..1 Sale a. Each new car can be sold once b. A sale can involve multiple new cars c. Each new car can be sold multiple times d. No new cars are in inventory e. None of the above
a. A sale can involve multiple new cars
Brokers 1..1 0..* Buy Sell Transactions Which describes the relationship? a. Each Buy Sell Transactions involves one Broker b. Each Buy Sell Transactions involves many Broker c. Each Buy Sell Transactions is involves in a min of 0 Broker d. Each Buy Sell Transactions involves a max of many Broker e. Both a and d are correct
a. Each Buy Sell Transactions involves one Broker
Stocks 1..* 0..* Stock Exchanges Which describes this relationship? a. Each exchange trades at leas one stock. b. Each exchange trades only one stock. c. Stocks are traded in a minimum of zero exchanges. d. Stocks are traded in a maximum of many exchanges. e. Both A and D are correct.
e. Both A and D are correct
Stock Exchanges 0..* 1..* Stocks Which describes this relationship? a. Stocks are traded in only one exchange. b. Stocks are traded in at least one exchange. c. Stocks are traded in a minimum of zero exchanges. d. Stocks are traded in a maximum of many exchanges. e. Both C and D are correct
e. Both C and D are correct
Stocks 1..1 0..*Buy Sell Transactions Which Describes the relationships? a.Each transaction involves at least one stock b. Each transaction involves only one stock. c. Each transaction involves a min of 0 stocks. d. Each transaction involves a max of many stocks. e. Both a and b are correct
e. Both a and b are correct
Buy/Sell Transactions 0..* 1..1Brokers Which describes the relationship? a.Each Broker is involved in one Buy Sell transaction. b. Each Broker is in involved in many Buy Sell Transactions c. Each Broker is in involved in a min of 1 Buy Sell Transactions d. Each Broker is in involved in a min of 0 Buy Sell Transactions e. Both b and d are correct
e. Both b and d are correct
Which of the following is true to implement the stock exchanges and brokers classes in the preceding UML class diagram in a databases? a. The primary key of Brokers is a foreign key in Stock Exchanges b. The primary key of Stock Exchanges is a foreign key in Brokers c. The association between Brokers and Stock Exchanges is implemented as a linking table. Both a and b are true e. None are true
e. None are true
Which of the following is true to implement the buy sell transactions and stocks classes and the association between them in a preceding UML class diagram in a database? a. The primary key of Stocks is a foreign key in Buy Sell transactions b. The primary key of Buy Sell Transactions is a foreign key in Stocks c. The association between Stocks and Buy Sell Transactions is implemented as a linking table d Both A and B e. Non are true
a. The primary key of Stocks is a foreign key in Buy Sell transactions
Buy Sell 0..* 1..1 Stocks Which describes the relationship? a.each stock is bough sold at least once b. Each stock is bought sold only once c. Each stock is bought sold a max of many times d. Each stock is bought sold a min of many times e. Both A and C
c. Each stock is bought sold a max of many times
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? a. The primary key of Stocks is a foreign key in Stock Exchanges. b. The primary key of Stock Exchanges is a foreign key in Stocks. c. The association between Stocks and Stock Exchanges is implemented as a linking table. d. Both A and B are true e. None of these are true
c. The association between Stocks and Stock Exchanges is implemented as a linking table