30 Questions
Which category refers to the time interval of interest to the enterprise?
When
Which category refers to the location of interest to the enterprise?
Where
What is the term used to represent an occurrence or value of a particular entity?
Entity Instance
In data models, how are entities typically depicted?
Rectangles
Which term is often used in relational schemes to refer to a relationship?
Association
What is the purpose of cardinality in a relationship?
To specify the number of entities participating in the relationship
What is the arity of a relationship?
The number of entities involved in the relationship
In relational modeling, where are child entities typically placed in a recursive relationship?
On the many side of the relationship
Which of the following is NOT one of the six most commonly used data modeling schemes?
Structured
What are the three levels of detail at which data models exist?
Conceptual, Logical, Physical
What is the goal of data modeling and design?
To create a foundation for data governance programs
What are some examples of components in a data model?
Entities, Relationships, Facts, Attributes
Which one of the following is NOT one of the four main types of data that can be modeled?
Detail transaction information
What is the main purpose of data modeling?
To understand organizational data
What are the basic building blocks of most data models?
Entities, relationships, attributes, and domains
What is the definition of an entity in data modeling?
A thing about which an organization collects information
Which of the following is an example of a binary relationship in a data model?
Figure 34
In a data model, what is a foreign key used for?
To represent a relationship between two entities
What is the difference between a simple key and a surrogate key?
A simple key is visible to end users, while a surrogate key is not
Which of the following is an example of a compound key in a data model?
Universal Product Code (UPC)
Which of the following is NOT a goal of data modeling?
To provide the starting point for customization, integration, or replacement of an application
What is the purpose of data models in data management?
To provide a common vocabulary around data
What does a data model help explain?
All of the above
What is the role of a data model in data understanding?
All of the above
Which of the following is an example of a candidate key for a customer entity?
Email address
What is the difference between a super key and a candidate key?
A super key is any set of attributes that uniquely identify an entity instance, while a candidate key is a minimal set of one or more attributes that identifies the entity instance to which it belongs.
What is a primary key?
A surrogate key that uniquely identifies an entity instance.
What is an alternate key?
A candidate key that was not chosen as the unique identifier for an entity.
What is the difference between a business key and a surrogate key?
A business key is one or more attributes that a business professional would use to retrieve a single entity instance, while a surrogate key is a candidate key that is chosen to be the unique identifier for an entity.
Can an entity have multiple candidate keys?
Yes, an entity can have multiple candidate keys.
Test your knowledge of relational data models and information engineering notation with this quiz. Explore how recursive relationships can be modeled as hierarchies or networks. Challenge yourself with examples and terminology related to unary relationships and prerequisites in data modeling.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free