Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is a well-formed business rule?

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

What is the best description of the relationship between employee and vehicle in the following UML class diagram?

Accepted Answer

A) Zero-to-one. 
B) Zero-to-zero. 
C) One-to-one. 
D) One-to-many. 
A) Zero-to-one. 
B) Zero-to-zero. 
C) One-to-one. 
D) One-to-many.

Question 6

Obligatory business rules state what should not occur.

Accepted Answer

A) True 
 B)False

Question 7

A Class is a separately identifiable collection of business relationships.

Accepted Answer

A) True 
 B)False

Question 8

Which of following are possible options for minimum multiplicities?

Accepted Answer

A) 0 and 1. 
B) 0 and *. 
C) * and 1. 
D) 0,1,and *. 
A) 0 and 1. 
B) 0 and *. 
C) * and 1. 
D) 0,1,and *.

Question 9

Which of the following is not a criterion for selection of a primary key?

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

What is the best description of the relationship between instructor and course in the following UML class diagram?

Accepted Answer

A) One-to-zero. 
B) One-to-many. 
C) Zero-to-many. 
D) Many-to-many. 
A) One-to-zero. 
B) One-to-many. 
C) Zero-to-many. 
D) Many-to-many.

Question 13

Which of the following is not something a model of database structures must be able to describe?

Accepted Answer

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

Question 14

Logical database structure models,including UML Class Diagrams,must be able to describe which of the following?

Accepted Answer

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 
B) The activities performed in the business process. 
C) The operations performed on the database. 
D) The Bachman diagram.

Question 15

Which of the following is not one of the building blocks used for creating UML Class Diagrams?

Accepted Answer

A) Classes. 
B) Events. 
C) Associations. 
D) None of these other choices are used in UML Class Diagrams. 
A) Classes. 
B) Events. 
C) Associations. 
D) None of these other choices are used in UML Class Diagrams.

Question 16

Which of the following UML class diagrams depicts an aggregation relationship?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 17

When implementing the database from a UML class diagram,associations should be mapped to which of the following?

Accepted Answer

A) Tables. 
B) Fields. 
C) Relationships. 
D) Foreign keys. 
A) Tables. 
B) Fields. 
C) Relationships. 
D) Foreign keys.

Question 18

Which of the following best represents a business rule in a decision table where the decision table relates to shipping rules?

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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?

Accepted Answer

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

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

Which of the following is a well-formed business rule?

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

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

What is the best description of the relationship between employee and vehicle in the following UML class diagram?

Obligatory business rules state what should not occur.

A Class is a separately identifiable collection of business relationships.

Which of following are possible options for minimum multiplicities?

Which of the following is not a criterion for selection of a primary key?

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

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

What is the best description of the relationship between instructor and course in the following UML class diagram?

Which of the following is not something a model of database structures must be able to describe?

Logical database structure models,including UML Class Diagrams,must be able to describe which of the following?

Which of the following is not one of the building blocks used for creating UML Class Diagrams?

Which of the following UML class diagrams depicts an aggregation relationship?

When implementing the database from a UML class diagram,associations should be mapped to which of the following?

Which of the following best represents a business rule in a decision table where the decision table relates to shipping rules?

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

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Relational Databases and Enterprise Systems

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language Xbrl

Data Analytics in Accounting: Concepts and the Amps Model

Data Analytics in Accounting: Tools and Practice

Emerging Technologies: Blockchain and Ai Automation

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing Ais

The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology

Evaluating Ais Investments

Filters

Exam 3: Data Modeling

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

Which of the following is a well-formed business rule?

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

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

What is the best description of the relationship between employee and vehicle in the following UML class diagram?

Obligatory business rules state what should not occur.

A Class is a separately identifiable collection of business relationships.

Which of following are possible options for minimum multiplicities?

Which of the following is not a criterion for selection of a primary key?

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

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

What is the best description of the relationship between instructor and course in the following UML class diagram?

Which of the following is not something a model of database structures must be able to describe?

Logical database structure models,including UML Class Diagrams,must be able to describe which of the following?

Which of the following is not one of the building blocks used for creating UML Class Diagrams?

Which of the following UML class diagrams depicts an aggregation relationship?

When implementing the database from a UML class diagram,associations should be mapped to which of the following?

Which of the following best represents a business rule in a decision table where the decision table relates to shipping rules?

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

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Relational Databases and Enterprise Systems

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language Xbrl

Data Analytics in Accounting: Concepts and the Amps Model

Data Analytics in Accounting: Tools and Practice

Emerging Technologies: Blockchain and Ai Automation

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing Ais

The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology

Evaluating Ais Investments

Filters