Chapter 3

Ace your homework & exams now with Quizwiz!

Identify process steps.

is not a basic step in modeling process decision requirements

Accumulation

is not a general category of operational decision

Optional enforcement

is not an enforcement level for a business rule

Describe the sequence of activities

is not an objective of a structure model

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

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

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

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

-The primary key of Brokers is a foreign key in Stock Exchanges. -The primary key of Stock Exchanges is a foreign key in Brokers. -The association between Brokers and Stock Exchanges is implemented as a linking table. => None of these are true.

is true to implement the Stock Exchanges and Brokers classes in the preceding UML class diagram in a database

The association between Stocks and Stock Exchanges is implemented as a linking table.

is true to implement the Stock Exchanges and Stocks classes and the association between them in the preceding UML class diagram in a database

Identify the classes and associations in the following narrative, and draw a class diagram with multiplicities. Then answer questions 1 to 8 below: Paige runs a small frozen yogurt shop. She buys several flavors of frozen yogurt mix from her yogurt supplier. She buys plastic cups in several sizes from another supplier. She buys cones from a third supplier. She counts yogurt and cones as inventory, but she treats the cups as an operating expense and doesn't track any cup inventory. Required: 1. How many classes did you include in your diagram? 2. Which of the following best describes the names of the classes that you selected for your diagram? 3. If there is an association between a SUPPLIERS class and a PURCHASES class, which of the following best describes the multiplicities next to the PURCHASES class? Assume that SUPPLIERS are added to the database before the first purchase. 4. If there is an association between a SUPPLIERS class and a PURCHASES class, which of the following best describes the multiplicities next to the SUPPLIERS class? Assume that SUPPLIERS are added to the database before the first purchase. 5. If there is an association between an INVENTORY class and a PURCHASES class, which of the following best describes the multiplicities next to the PURCHASES class? Assume that INVENTORY records are added to the database before the first purchase. 6. If there is an association between an INVENTORY class and a PURCHASES class, which of the following best describes the multiplicities next to the INVENTORY class? Assume that INVENTORY records are added to the database before the first purchase. 7. If there is an association between a PAIGE class and a SUPPLIERS class, which of the following best describes the multiplicities next to the PAIGE class? Assume that SUPPLIERS records are added to the database before the first purchase. 8. Assume that Paige's yogurt business expanded and Paige hired several employees to purchase inventory from suppliers. What class(es) and association(s) would you add to the diagram to track this information?

1. 3 2. Inventory, Purchases, Suppliersradio button checked 3. Minimum 0, Maximum * 4. Minimum 1, Maximum 1 5. Minimum 0, Maximum * 6. Minimum 0, Maximum * 7. There is no association between PAIGE and SUPPLIERS in the model 8. An EMPLOYEES class and an association between EMPLOYEES and PURCHASES.

an example of an obligatory business rule

Both "Customers must provide a valid credit card number" and "Customers must enter a shipping address" are obligatory business rules.

Contrast the UML class diagrams with the entity-relationship diagrams shown in Appendix A. Which of the following pairs are not equivalent?

Class and Relationship

Both "Stocks are traded in a minimum of zero exchanges" and "Stocks are traded in a maximum of many exchanges" are correct.

best describes the meaning of the multiplicities next to the number 1 in the preceding diagram

Both "Each exchange trades at least one stock" and "Each exchange trades a maximum of many stocks" are correct.

best describes the meaning of the multiplicities next to the number 2 in the preceding diagram

Both "Each transaction involves at least one stock" and "Each transaction involves only one stock" are correct.

best describes the meaning of the multiplicities next to the number 3 in the preceding diagram

Each stock is bought/sold a maximum of many times.

best describes the meaning of the multiplicities next to the number 4 in the preceding diagram

Each Broker is involved in a minimum of zero Buy/Sell Transactions.

best describes the meaning of the multiplicities next to the number 5 in the preceding diagram

Each sale can result in many subsequent cash receipts.

best describes the meaning of this diagram

Every class must have at least one student enrolled.

best describes the meaning of this entity-relationship diagram


Related study sets

( 4 ) - Disability Income Insurance

View Set

Intermediate Accounting ch 18, 15th edition

View Set