ACCT 3303 CH. 3

In Unified Modeling Language (UML) the options for minimum multiplicity values are 1 and *. T/F

False

Obligatory business rules state what should not occur. T/F

False

Associations can indicate the roles that one Class takes in its business relationship with another Class. T/F

True

Business rules set criteria for branching in activity models. T/F

True

In Unified Modeling Language (UML) Class diagrams, Associations are represented by dashed lines. T/F

False

In Unified Modeling Language (UML) primary keys may be blank. T/F

False

In Unified Modeling Language (UML) the options for maximum multiplicity values are 0 and *. T/F

False

In Unified Modeling Language (UML) the options for minimum multiplicity values are 0, 1, and 2. T/F

False

Which of following are possible options for minimum multiplicities? A) 0 and 1. B) 0 and *. C) * and 1. D) 0, 1, and *.

A) 0and 1

Which of the following is not a form of business rules? A) Compulsory. B) Obligatory. C) Prohibited. D) Allowed.

A) Compulsory

Consider an association between a Cities class and a Neighborhoods class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cities class are 1..1 and the multiplicities next to the Neighborhoods class are 1..*. Which of the following is the best way to implement that association in your database? A) Post the primary key of Cities as a foreign key in Neighborhoods. B) Post the primary key of Neighborhoods as a foreign key in Cities.4 C) Create a linking table. D) None of these choices are correct.

A) Post the primary key of Cities as a foreign key in Neighborhoods

Consider an association between a Customers class and a Sale class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Customers class are 1..1 and the multiplicities next to the Sale class are 0..*. Which of the following is the best way to implement that association in your database? A) Post the primary key of Customers as a foreign key in Sales. B) Post the primary key of Sales as a foreign key in Customers. C) Create a linking table. D) None of these choices are correct.

A) Post the primary key of Customers as a foreign key in sales

Consider an association between a Pet Owners class and a Pets class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Pet Owners class are 1..1 and the multiplicities next to the Pets class are 1..*. Which of the following is the best way to implement that association in your database? A) Post the primary key of Pet Owners as a foreign key in Pets. B) Post the primary key of Pets as a foreign key in Pet Owners. C) Create a linking table. D) None of these choices are correct.

A) Post the primary key of of Pet Owners as a foreign key in Pets

Which of the following is not a valid enforcement level for business rules? A) Segregation. B) Pre-override. C) Strict Enforcement. D) Post-override.

A) Segregation

Logical database structure models, including UML Class Diagrams, must be able to describe which of the following? A) The attributes of the entities B) The activities performed in the business process. C) The operations performed on the database. D) The Bachman diagram.

A) The attributes of the entities

Which of the following is most similar to the relationship between the UML class diagram and the database? A) The relationship between a blueprint and building. B) The relationship between driving directions and a map. C) The relationship between raw materials and finished goods. D) The relationship between cooking instructions and ingredients.

A) The relationship between a blueprint and building

Which situation best exemplifies why anaylsts must understand process decision requirements? A) A business accepts cash, checks and all major credit cards B )A business can only transact with retailers who have a valid business license C) A business sells multiple types of widgets D) A business has three bank accounts

B) A business can only transact with retailers who have a valid business license

Which of the following statements about foreign keys is not true? A) A foreign key can be a combination of attributes. B) A foreign key should never be linked to a primary key in another table. C) Foreign key must match values of the linked primary key. D) Foreign keys support a defined association.

B) A foreign key should never be linked to a primary key in another table

Which of the following would be least likely to be represented with a Unified Modeling Language (UML) Class? A) Trucks B) Currency C) Employees D) Bank Account

B) Currency

Which of the following is not one of the building blocks used for creating UML Class Diagrams? A) Classes. B) Events. C) Associations. D) None of these other choices are used in UML Class Diagrams.

B) Events

Consider an association between a Cash Disbursements class and a Cash Accounts class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Cash Accounts class are 1..1. Which of the following is the best way to implement that association in your database? A)Post the primary key of Cash Disbursements as a foreign key in Cash Accounts. B)Post the primary key of Cash Accounts as a foreign key in Cash Disbursements. C)Create a linking table. D)None of these choices are correct.

B) Post the primary key of Cash Accounts as a foreign key in Cash Disbursements

Consider an association between a Cash Disbursements class and a Vendors class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Vendors class are 1..1. Which of the following is the best way to implement that association in your database? A) Post the primary key of Cash Disbursements as a foreign key in Vendors. B) Post the primary key of Vendors as a foreign key in Cash Disbursements. C) Create a linking table. D) None of these choices are correct.

B) Post the primary key of Vendors as a foreign key in Cash Disbursements

Consider an association between a Deliveries class and a Shipping Companies class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Deliveries class are 0..* and the multiplicities next to the Shipping Companies class are 1..1. Which of the following is the best way to implement that association in your database? A) Post the primary key of Deliveries as a foreign key in Shipping Companies. B) Post the primary key of Shipping Companies as a foreign key in Deliveries. C) Create a linking table. D) None of these choices are correct.

B) Post the primary key of shipping Companies as a foreign key in Deliveries

Which of the following is not something a model of database structures must be able to describe? A) The entities or things in the domain of interest. B) The sequence that entities are accessed. C) The cardinalities that describe how many instances of one entity can be related to another. D) The attributes or characteristics of the entities and relationships.

B) The sequence that entities are accessed

Which of the following is not a best practice in preparing Unified Modeling Language (UML) Class diagrams? A) Opt for simplicity. B) Use various size class rectangles. C) Avoid crossing lines whenever possible. D) Avoid confusing abbreviations.

B) Use various size class rectangles

Which of the following best represents a business rule in a decision table where the decision table relates to shipping rules? A) Customer status in a rewards program. B) What to charge the customer for shipping based on location. C) Type of payment for the shipping. D) Choice of shipping carrier.

B) What to charge the customer for shipping based on location

19 Consider an association between a Sales class and an Inventory class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Sales class are 0..* and the multiplicities next to the Inventory class are 1..*. Which of the following is the best way to implement that association in your database? A) Post the primary key of Sales as a foreign key in Inventory. B) Post the primary key of Inventory as a foreign key in Sales. C) Create a linking table. D) None of these choices are correct.

C) Create a linking table

Consider an association indicating professional licensing status between an Accountant class and a States class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Accountants class are 0..* and the multiplicities next to the States class are 0..*. Which of the following is the best way to implement that association in your database? A) Post the primary key of Accountants as a foreign key in States. B) Post the primary key of States as a foreign key in Accountants. C) Create a linking table. D) None of these choices are correct.

C) Create a linking table

When implementing the database from a UML class diagram, attributes should be mapped to which of the following? A) Tables. B) Relationships. C) Fields. D) Indexes.

C) Fields

Which of the following is not a step in using a Unified Modeling Language (UML) Class model to prepare a database? A) Map Classes to Tables. B) Map Attributes to Table Fields. C) Map Associations to Primary Keys. D) Map Associations to Foreign Keys.

C) Map Associations to Primary Keys

Which of the following is the best description of an association? A) A group of classes. B) Grouping of items. C) The relationship between two classes. D) The number of times one class is related to another.

C) The relationship between two classes

An aggregation relationship is a form of generalization relationships. T/F

False

Which of the following is a well-formed business rule? A) Customers must be over 18 years of age. B) Customers may not be under 18 years of age. C) Customers must pay in U. S. dollars. D )All of these are well-formed business rules.

D) All of these are well-formed business rules

A database being built to support customer purchase information would likely have the following classes except: A) Customer B) Order C) Inventory D) Color

D) Color

When implementing the database from a UML class diagram, associations should be mapped to which of the following? A) Tables. B) Fields. C) Relationships. D) Foreign keys.

D) Foreign keys

Which of the following is not a criterion for selection of a primary key? A) The primary key cannot be NULL (blank). B) The primary key should be controlled by the organization assigning it. C) Primary keys with sequential values make it easier to spot gaps in the data. D) The primary key should always be numeric.

D) The primary key should always be numeric

Which of the following best describes the purpose of a primary key? A) Allows linking two or more tables. B) Indicates the minimum multiplicities for an association. C) Matches values of foreign keys in other classes. D) Uniquely identifies each instance of the class.

D) Uniquely identifies each instance of the class

A Class is a separately identifiable collection of business relationships. T/F

False

A database should have exactly the same number of tables as there are Classes in the Unified Modeling Language (UML) Class diagram from which the database is developed. T/F

False

A generalization relationship models a grouping of things that share common characteristics. T/F

True

In Unified Modeling Language (UML) Class diagrams, a Class is represented by a rectangle. T/F

True

In Unified Modeling Language (UML) attributes are characteristics of individual instances of a Class. T/F

True

In Unified Modeling Language (UML) foreign keys allow tables to be linked together in a database. T/F

True

In Unified Modeling Language (UML) primary keys cannot by NULL. T/F

True

In Unified Modeling Language (UML) the options for maximum multiplicity values are 1 and *. T/F

True

The Object Management Group maintains the standard for Unified Modeling Language (UML) Class diagrams. T/F

True

Unified Modeling Language (UML) Class diagrams describe the logical structure of a database system. T/F

True

When building a database from Unified Modeling Language (UML) Class diagrams, each instance of each Class becomes a row in the corresponding table. T/F

True