DMC Data Modeling Fundamentals 3

Question 1

What is a recursive (or self-referencing) relationship in data modeling?

Accepted Answer

A relationship where an entity is associated with instances of itself

Answer

A relationship that loops through three tables

Answer

A circular foreign key between two tables

Answer

A stored procedure that calls itself

Question 2

What is a subtype in data modeling?

Accepted Answer

A specialized category of a supertype entity that inherits its attributes

Answer

A data type smaller than INTEGER

Answer

A secondary index on a table

Answer

A lookup table containing code values

Question 3

What principle ensures that every fact in a data model is stored in exactly one place?

Accepted Answer

Single Source of Truth (SSOT)

Answer

Referential integrity

Answer

Entity completeness

Answer

Domain constraint

Question 4

In an ERD, what does a crow's foot notation symbol at the end of a relationship line represent?

Accepted Answer

Many (zero or more)

Answer

One and only one

Answer

Zero or one

Answer

Primary key

Question 5

Which of the following best describes an associative entity (also known as an intersection or bridge entity)?

Accepted Answer

An entity that links two or more entities in a many-to-many relationship and may contain its own attributes

Answer

An entity that has no attributes other than its primary key

Answer

An entity used only in physical data models

Answer

An entity representing a lookup or code table

Question 6

What is the primary goal of a conceptual data model?

Accepted Answer

To capture high-level business concepts and their relationships independent of technology

Answer

To define indexes and storage parameters

Answer

To specify SQL DDL scripts for deployment

Answer

To document ETL transformation rules