Question 1

Which of the following UML class diagrams depicts an aggregation relationship?
A) 
B) 
C) 
D)

Accepted Answer

The answer of Which of the following UML class diagrams...

Question 2

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.

Accepted Answer

Associations in a UML class diagram represent relationships between classes. When implementing the database, these relationships are typically mapped to foreign keys in the tables that represent the classes.

Question 3

The following UML class diagram should result in how many tables in the relational database? 
A)4
B)5
C)6
D)7

Accepted Answer

There are five classes with a one-to-many relationship between them. This results in five tables in the relational database.

Question 4

What is the best description of the relationship between instructor and course in the following UML class diagram? 
A)One-to-zero.
B)One-to-many.
C)Zero-to-many.
D)Many-to-many.

Accepted Answer

The answer of What is the best description of the...

Question 5

What is the best description of the relationship between employee and vehicle in the following UML class diagram? 
A)Zero-to-one.
B)Zero-to-zero.
C)One-to-one.
D)One-to-many.

Accepted Answer

The UML class diagram shows a one-to-one relationship between the Employee and Vehicle classes, meaning each employee can have only one vehicle assigned to them and each vehicle can be assigned to only one employee.

Question 6

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

Accepted Answer

Segregation is not a valid enforcement level for business rules. The other three options (Pre-override, Strict Enforcement, and Post-override) are valid options for enforcing business rules.

Question 7

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

Accepted Answer

Option B indicates a process decision requirement that must be understood by analysts. The business can only transact with retailers who have a valid business license. Understanding this requirement is critical to ensuring that the business complies with regulations and only conducts business with authorized parties. Options A, C, and D describe business operations, but do not highlight process decision requirements.

Question 8

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.

Accepted Answer

Attributes in a UML class diagram are mapped to fields in a database. Fields represent the columns in a table, where each column holds a specific piece of data about an instance of an entity.

Question 9

The following UML class diagram should result in how many tables in the relational database? 
A)4
B)5
C)6
D)7

Accepted Answer

The answer of The following UML class diagram should result...

Question 10

Which attribute in the following class would make the best primary key? 
A)Customer
B)Customer Name
C)E-mail address
D)Customer ID

Accepted Answer

The attribute "Customer ID" would make the best primary key because it appears to be a unique identifier for each customer. The other attributes may not be unique for each customer, meaning that they could not serve as reliable primary keys.

Question 11

What is the best description of the relationship between employee and vehicle in the following UML class diagram? 
A)One-to-one.
B)One-to-many.
C)Zero-to-many.
D)One-to-zero.

Accepted Answer

The answer of What is the best description of the...

Question 12

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.

Accepted Answer

A UML class diagram is a blueprint for the design of object-oriented software systems, much like a blueprint is a plan for a building. Similarly, a database is a structured representation of data, much like a building is a structured representation of a blueprint.

Question 13

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

Accepted Answer

The classes related to customer purchases would include information about the customers themselves (Customer class), the orders they have placed (Order class), and the items available for purchase (Inventory class). The Color class would not be relevant to customer purchases and therefore would not be included in the database.

Quiz 3: Data Modeling

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?

The following UML class diagram should result in how many tables in the relational database?

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

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 situation best exemplifies why anaylsts must understand process decision requirements?

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

The following UML class diagram should result in how many tables in the relational database?

Which attribute in the following class would make the best primary key?

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

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

A database being built to support customer purchase information would likely have the following classes except: