AIS CH. 3
Which of the following best describes the meaning of the multiplicities next to the number 6 in the preceding diagram? A- Each Buy/Sell Transaction involves one Broker. B- Each Buy/Sell Transaction involves many Brokers. C- Each Buy/Sell Transaction involves a minimum of zero Brokers. D- Each Buy/Sell Transaction involves a maximum of many Brokers. E- Both "Each Buy/Sell Transaction involves one Broker" and "Each Buy/Sell Transaction involves a maximum of many Brokers" are correct.
A- Each Buy/Sell Transaction involves one Broker.
Which of the following best describes the meaning of this UML class diagram? REFER TO HW FOR DIAGRAM 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 choices are correct.
A- Each new car can be sold once.
Which of the following best describes the meaning of this diagram? REFER TO HW FOR DIAGRAM A- Each sale can result in many subsequent cash receipts. B- Each cash receipt can apply to many sales. C- All sales must have cash receipts. D- Each sale can result in only one cash receipt. E- None of the choices are correct.
A- Each sale can result in many subsequent cash receipts.
Which of the following is not a basic step in modeling process decision requirements? A- Identify process steps. B- Decompose and refine requirements. C- Specify decision information and knowledge requirements. D- Identify required decisions. E- Document decisions and how they impact business objectives.
A- Identify process steps.
Which of the following symbols is used to represent a class in a UML class diagram? A- Rectangle B- Oval C- Arrow line D- Diamond
A- Rectangle
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? 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 "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. E- None of these are true.
A- The primary key of Brokers is a foreign key in Buy/Sell Transactions.
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? 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 "The primary key of Stocks is a foreign key in Buy/Sell Transactions" and "The primary key of Buy/Sell Transactions is a foreign key in Stocks" are true. E- None of these are true.
A- The primary key of Stocks is a foreign key in Buy/Sell Transactions.
Which of the following statements concerning this class diagram with multiplicities is not true? REFER TO HW FOR DIAGRAM A- An order can involve only one customer. B- A customer can place only one order. C- A customer can place many orders. D- A customer may not have ordered yet. E- All of the choices are true.
B- A customer can place only one order.
Contrast the UML class diagrams with the entity-relationship diagrams shown in Appendix A. Which of the following pairs are not equivalent? A- Class and Entity B- Class and Relationship C- Association and Relationship D- Multiplicity and Cardinality E- All of these are equivalent.
B- Class and Relationship
Which of the following best describes the meaning of the multiplicities next to the number 4 in the preceding diagram? A- Each stock is bought/sold at least once. B- Each stock is bought/sold only once. C- Each stock is bought/sold a maximum of many times. D- Each stock is bought/sold a minimum of many times. E- Both "Each stock is bought/sold at least once" and "Each stock is bought/sold a maximum of many times" are correct.
B- Each stock is bought/sold only once.
Which of the following best describes the meaning of this entity-relationship diagram? REFER TO HW FOR DIAGRAM A- Every student is enrolled in many classes. B- Every class must have at least one student enrolled. C- Every student must be enrolled in at least one class. D- No students are enrolled in any classes. E- None of the choices are correct.
B- Every class must have at least one student enrolled.
Which of the following is not a general category of operational decision? A- Eligibility B- Validation C- Opportunity D- Accumulation E- Risk
D- Accumulation
Which of the following is not an objective of a structure model? A- Designate things of interest in the business domain. B- Describe characteristics of things of interest in the business domain. C- Support relational database design. D- Describe the sequence of activities. E- All of the choices are objectives of structure models.
D- Describe the sequence of activities.
Which of the following best describes the meaning of the multiplicities next to the number 5 in the preceding diagram? A- Each Broker is involved in one Buy/Sell Transaction. B- Each Broker is involved in many Buy/Sell Transactions. C- Each Broker is involved in a minimum of one Buy/Sell Transaction. D- Each Broker is involved in a minimum of zero Buy/Sell Transactions. E- Both "Each Broker is involved in many Buy/Sell Transactions" and "Each Broker is involved in a minimum of zero Buy/Sell Transactions" are correct.
D- Each Broker is involved in a minimum of zero Buy/Sell Transactions.
Which of the following is not an enforcement level for a business rule? A- Guideline B- Post-override enforcement C- Pre-override enforcement D- Optional enforcement E- Strict enforcement
D- Optional enforcement
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 "The primary key of Stocks is a foreign key in Stock Exchanges" and "The primary key of Stock Exchanges is a foreign key in Stocks" are true. E- None of these are true.
C- The association between Stocks and Stock Exchanges is implemented as a linking table.
Which of the following statements is true about the following class diagram? REFER TO HW FOR DIAGRAM A- A sale can involve zero inventory items. B- A sale can involve one inventory item. C- A sale can involve many inventory items. D- "A sale can involve zero inventory items" and "A sale can involve many inventory items" are true. E- "A sale can involve one inventory item" and "A sale can involve many inventory items" are true.
E- "A sale can involve one inventory item" and "A sale can involve many inventory items" are true.
Which of the following is an example of an obligatory business rule? A- Customers must provide a valid credit card number. B- Customers must enter a shipping address. C- Customers may not enter a post office box as a shipping address. D- Customers may use Visa or MasterCard. E- Both "Customers must provide a valid credit card number" and "Customers must enter a shipping address" are obligatory business rules.
E- Both "Customers must provide a valid credit card number" and "Customers must enter a shipping address" are obligatory business rules.
Which of the following best describes the meaning of the multiplicities next to the number 2 in the preceding diagram? A- Each exchange trades at least one stock. B- Each exchange trades only one stock. C- Each exchange trades a minimum of zero stocks. D- Each exchange trades a maximum of many stocks. E- Both "Each exchange trades at least one stock" and "Each exchange trades a maximum of many stocks" are correct.
E- Both "Each exchange trades at least one stock" and "Each exchange trades a maximum of many stocks" are correct.
Which of the following best describes the meaning of the multiplicities next to the number 3 in the preceding diagram? A- Each transaction involves at least one stock. B- Each transaction involves only one stock. C- Each transaction involves a minimum of zero stocks. D- Each transaction involves a maximum of many stocks. E- Both "Each transaction involves at least one stock" and "Each transaction involves only one stock" are correct.
E- Both "Each transaction involves at least one stock" and "Each transaction involves only one stock" are correct.
Refer to this diagram to answer questions 11 through 20. Which of the following best describes the meaning of the multiplicities next to the number 1 in the preceding diagram? 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 "Stocks are traded in a minimum of zero exchanges" and "Stocks are traded in a maximum of many exchanges" are correct.
E- Both "Stocks are traded in a minimum of zero exchanges" and "Stocks are traded in a maximum of many exchanges" are correct.
Which of the following is true to implement the Stock Exchanges and Brokers classes in the preceding UML class diagram in a database? 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. D- Both "The primary key of Brokers is a foreign key in Stock Exchanges" and "The primary key of Stock Exchanges is a foreign key in Brokers" are true. E- None of these are true.
E- None of these are true.