Question 1

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

Accepted Answer

A) Tables. 
B) Relationships. 
C) Fields. 
D) Indexes. 
A) Tables. 
B) Relationships. 
C) Fields. 
D) Indexes.

Question 2

An aggregation relationship is a form of generalization relationships.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

Which of the following is not a valid enforcement level for business rules?

Accepted Answer

A) Segregation. 
B) Pre-override. 
C) Strict Enforcement. 
D) Post-override. 
A) Segregation. 
B) Pre-override. 
C) Strict Enforcement. 
D) Post-override.

Question 5

Which of the following best describes the purpose of a primary key?

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is most similar to the relationship between the UML class diagram and the database?

Accepted Answer

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

Question 8

Which situation best exemplifies why anaylsts must understand process decision requirements?

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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?

Accepted Answer

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. 
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. 
B) Post the primary key of Neighborhoods as a foreign key in Cities. 
C) Create a linking table. 
D) None of these choices are correct.

Question 11

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?

Accepted Answer

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

Question 12

Which of the following is not a best practice in preparing Unified Modeling Language (UML)Class diagrams?

Accepted Answer

A) Opt for simplicity. 
B) Use various size class rectangles. 
C) Avoid crossing lines whenever possible. 
D) Avoid confusing abbreviations. 
A) Opt for simplicity. 
B) Use various size class rectangles. 
C) Avoid crossing lines whenever possible. 
D) Avoid confusing abbreviations.

Question 13

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

Accepted Answer

A) True 
 B)False

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

An aggregation relationship is a form of generalization relationships.

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

Which of the following is not a valid enforcement level for business rules?

Which of the following best describes the purpose of a primary key?

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

Which of the following is most similar to the relationship between the UML class diagram and the database?

Which situation best exemplifies why anaylsts must understand process decision requirements?

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

Which of the following is not a best practice in preparing Unified Modeling Language (UML)Class diagrams?

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

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

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

An aggregation relationship is a form of generalization relationships.

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

Which of the following is not a valid enforcement level for business rules?

Which of the following best describes the purpose of a primary key?

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

Which of the following is most similar to the relationship between the UML class diagram and the database?

Which situation best exemplifies why anaylsts must understand process decision requirements?

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

Which of the following is not a best practice in preparing Unified Modeling Language (UML)Class diagrams?

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

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