DMC Conceptual and Logical Data Design 3

Question 1

In logical data modeling, what is the purpose of a business rule?

Accepted Answer

To capture constraints and policies that govern data and must be enforced by the model

Answer

Business rules define constraints, policies, and conditions that data must satisfy, and they guide the structure and constraints built into the logical data model.

Question 2

What is a multi-valued attribute?

Accepted Answer

An attribute that can hold multiple independent values for a single entity instance

Answer

A multi-valued attribute is one that can hold more than one value simultaneously for the same entity, such as a person having multiple phone numbers.

Question 3

Which normal form specifically addresses multi-valued dependencies?

Accepted Answer

4NF

Answer

Fourth Normal Form (4NF) eliminates non-trivial multi-valued dependencies, ensuring a table doesn't independently store two or more multi-valued facts about an entity.

Question 4

What is an abstract entity in a supertype/subtype model?

Accepted Answer

A supertype entity that cannot have direct instances — all instances must belong to a subtype

Answer

An abstract supertype has no instances of its own; every instance must be classified as one of its subtypes, such as EMPLOYEE being abstract with subtypes FULL_TIME and PART_TIME.

Question 5

Which ERD notation style uses rectangles for entities, diamonds for relationships, and ovals for attributes?

Accepted Answer

Chen notation

Answer

Chen notation, developed by Peter Chen in 1976, uses rectangles for entities, diamonds for relationships, and ovals for attributes in its ERD representation.

DMC - Data Modeling Certification Practice Test

DMC - Data Modeling Certification Practice Test

DMC Conceptual and Logical Data Design 3