Database Management Ultimate Quiz!

Reviewed by Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By BOSTON COLLEGE

BOSTON COLLEGE

Community Contributor

Quizzes Created: 1 | Total Attempts: 547

| Attempts: 547

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

1/49 Questions

Entity supertypes and subtypes are organized in a specialization hierarchy.
- True
- False

About This Quiz

Do you know what is database management? Database management allows the user to organize, store and retrieve information from a computer. It can also describe the data storage, operations, and security practices of a database administrator. This quiz will require you to know things like how entity subtypes and supertypes are organized in a specialization hierarchy and important inheritance characteristics. See moreThis quiz will teach you about database management and what it entails.

Database Management Ultimate Quiz! - Quiz

Quiz Preview

2.

Within a specialization hierarchy, a supertype can exist only within the context of a subtype.
- True
- False
Correct Answer

A. False

Explanation

This statement is false. Within a specialization hierarchy, a supertype can exist independently of any subtype. A supertype is a general category or class that encompasses multiple subtypes, which are more specific categories or classes. The supertype defines common attributes and behaviors shared by its subtypes, but it is not dependent on the existence of any specific subtype.

Rate this question:
3.

The entity supertype contains the common characteristics and the entity subtypes contain the unique characteristics of each entity subtype.
- True
- False
Correct Answer

A. True

Explanation

The explanation for the given correct answer is that in a supertype-subtype relationship, the supertype represents a general category that contains common attributes and behaviors shared by multiple subtypes. The subtypes, on the other hand, represent specific categories within the supertype and have their own unique attributes and behaviors. This allows for more flexibility and organization in the database design, as the supertype can be used to store common data while the subtypes can store specific data related to each subtype. Therefore, the statement that the entity supertype contains the common characteristics and the entity subtypes contain the unique characteristics of each entity subtype is true.

Rate this question:
4.

The property of the subtype discriminator enables an entity supertype to inherit the attributes and relationships of the subtype.
- True
- False
Correct Answer

A. False

Explanation

The statement is false because the property of the subtype discriminator does not enable an entity supertype to inherit the attributes and relationships of the subtype. In fact, the subtype discriminator is used to differentiate between different subtypes within the supertype and determine which attributes and relationships are specific to each subtype. It helps in determining which subtype an entity belongs to, but it does not facilitate inheritance of attributes and relationships from the subtype to the supertype.

Rate this question:
5.

One important inheritance characteristic is that all entity subtypes inherit their primary key attribute from their supertype.
- True
- False
Correct Answer

A. True

Explanation

Inheritance is a concept in object-oriented programming where subclasses inherit properties and behaviors from their superclasses. In the context of this question, the statement is true because when a subtype inherits from a supertype, it also inherits the primary key attribute. This means that the primary key attribute of the supertype is automatically inherited by all its entity subtypes, ensuring consistency and maintaining the relationship between the entities.

Rate this question:
6.

At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a 1:1 relationship.
- True
- False
Correct Answer

A. True

Explanation

The statement is true because in a specialization hierarchy, each subtype can have only one supertype. This means that for every subtype, there is a unique supertype. This 1:1 relationship ensures that each subtype inherits the attributes and behaviors of its supertype accurately.

Rate this question:
7.

Entity subtypes do not inherit the relationships in which the supertype entity participates.
- True
- False
Correct Answer

A. False

Explanation

Entity subtypes do inherit the relationships in which the supertype entity participates. This means that if a supertype entity is involved in a relationship, all of its subtypes will also be involved in that relationship. This allows for more flexibility and specificity in modeling relationships between entities.

Rate this question:
8.

In specialization hierarchies with multiple levels of supertype/subtypes, a lower-level supertype inherits all of the attributes and relationships from all of its upper-level subtypes.
- True
- False
Correct Answer

A. False

Explanation

In specialization hierarchies with multiple levels of supertype/subtypes, a lower-level supertype does not inherit all of the attributes and relationships from all of its upper-level subtypes. Instead, it only inherits the attributes and relationships from its immediate supertype. This means that if there are multiple levels of supertype/subtypes, a lower-level supertype will not automatically inherit attributes and relationships from all of its upper-level subtypes.

Rate this question:
9.

An entity supertype can have disjoint or overlapping entity subtypes.
- True
- False
Correct Answer

A. True

Explanation

An entity supertype refers to a higher-level entity that has common attributes and characteristics shared by multiple subtypes. Disjoint entity subtypes have no overlap in their attributes and are mutually exclusive, while overlapping entity subtypes share some common attributes. Therefore, it is possible for an entity supertype to have both disjoint and overlapping entity subtypes, making the statement "An entity supertype can have disjoint or overlapping entity subtypes" true.

Rate this question:
10.

Overlapping subtypes are subtypes that contain a unique subset of the supertype entity set.
- True
- False
Correct Answer

A. False

Explanation

The statement is false because overlapping subtypes are subtypes that can have overlapping sets of entities with other subtypes. In other words, an entity can belong to multiple subtypes simultaneously. Therefore, the statement that overlapping subtypes contain a unique subset of the supertype entity set is incorrect.

Rate this question:
11.

Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set.
- True
- False
Correct Answer

A. False

Explanation

Disjoint subtypes are subtypes that contain unique subsets of the supertype entity set, not nonunique subsets. In other words, each entity in the supertype can belong to only one of the disjoint subtypes. Therefore, the correct answer is False.

Rate this question:
12.

Implementing non-overlapping subtypes requires the use of one discriminator attribute for each subtype.
- True
- False
Correct Answer

A. False

Explanation

Implementing non-overlapping subtypes does not necessarily require the use of one discriminator attribute for each subtype. It is possible to implement non-overlapping subtypes without using a discriminator attribute by using other techniques such as separate tables or separate relationships. Therefore, the given statement is false.

Rate this question:
13.

The completeness constraint can be partial or total.
- True
- False
Correct Answer

A. True

Explanation

The statement is true because the completeness constraint can indeed be either partial or total. A partial completeness constraint means that not all possible values or combinations are allowed, while a total completeness constraint means that all possible values or combinations are allowed. Therefore, the completeness constraint can vary in its level of strictness, allowing for flexibility in data validation.

Rate this question:
14.

Generalization is based on grouping unique characteristics and relationships of the subtypes.
- True
- False
Correct Answer

A. False

Explanation

Generalization is actually based on grouping common characteristics and relationships of the subtypes, not unique ones. By identifying the shared attributes and connections between subtypes, generalizations can be made to describe a larger category or concept. Therefore, the statement provided in the question is incorrect.

Rate this question:
15.

Specialization is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype.
- True
- False
Correct Answer

A. True

Explanation

The given statement is true. Specialization is indeed a top-down process in which we identify more specific entity subtypes from a higher-level entity supertype. This process allows us to organize and classify entities based on their characteristics and relationships. By breaking down a higher-level entity into its subtypes, we can better understand and analyze the specific attributes and behaviors of each subtype.

Rate this question:

1
16.

An entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD.
- True
- False
Correct Answer

A. True

Explanation

An entity cluster is a concept in entity-relationship diagrams (ERD) where multiple entities and relationships are grouped together and represented as a single entity type. This allows for simplification and abstraction of complex relationships and entities in the ERD. By using an entity cluster, we can effectively represent and understand the relationships and connections between multiple entities in a more organized and manageable manner. Therefore, the statement that an entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD is true.

Rate this question:
17.

To model time-variant data, you must create a new entity in an M:N relationship with the original entity.
- True
- False
Correct Answer

A. False

Explanation

To model time-variant data, you do not necessarily need to create a new entity in an M:N relationship with the original entity. Time-variant data refers to data that changes over time, and it can be represented in various ways depending on the requirements of the system. One common approach is to add a timestamp attribute to the original entity, which allows tracking the changes over time without creating a new entity. Therefore, the statement that you must create a new entity in an M:N relationship with the original entity to model time-variant data is false.

Rate this question:
18.

A design trap occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world.
- True
- False
Correct Answer

A. True

Explanation

A design trap occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world. This means that the design or representation of the relationship does not accurately reflect how it exists in reality.

Rate this question:
19.

Some designs use redundant relationships as a way to simplify the design.
- True
- False
Correct Answer

A. True

Explanation

Redundant relationships in design refer to the inclusion of additional connections or pathways that serve the same purpose as existing ones. This redundancy can help simplify the design by providing backup options or alternative routes, which can improve reliability and fault tolerance. By having redundant relationships, if one connection fails or becomes unavailable, the system can still function properly through the redundant pathway. Therefore, using redundant relationships can indeed simplify the design and enhance its robustness.

Rate this question:
20.

The extended entity relationship model (EERM) is sometimes referred to as the ____.
- Entity relationship model
- Enhanced entity relationship model
- Entity clustering relationship model
- Extended entity relationship diagram
Correct Answer

A. Enhanced entity relationship model

Explanation

The extended entity relationship model (EERM) is sometimes referred to as the enhanced entity relationship model. This is because the EERM extends and enhances the basic entity relationship model by including additional concepts and features. These additions allow for more complex relationships, attributes, and constraints to be represented, making the model more powerful and expressive. Therefore, the term "enhanced" accurately describes the improvements and advancements made in the EERM compared to the basic entity relationship model.

Rate this question:
21.

____ is a generic entity type that is related to one or more entity subtypes.
- A subtype discriminator
- Inheritance
- A specialization hierarchy
- An entity supertype
Correct Answer

A. An entity supertype

Explanation

An entity supertype is a generic entity type that is related to one or more entity subtypes. It serves as a common entity that encompasses the shared attributes and relationships of its subtypes. By using an entity supertype, we can efficiently manage and organize data that is common to multiple subtypes. This allows for better data modeling and representation, as well as easier querying and analysis of the data.

Rate this question:

1
22.

The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
- Subtype discriminator
- Inheritance
- Specialization hierarchy
- Entity supertype
Correct Answer

A. Specialization hierarchy

Explanation

A specialization hierarchy depicts the arrangement of higher-level entity supertypes and lower-level entity subtypes. It shows the relationship between parent entities and child entities, where the child entities inherit attributes and behaviors from their parent entities. This hierarchy allows for the classification and organization of entities based on their shared characteristics and relationships.

Rate this question:
23.

The relationships depicted within the ____ are sometimes described in terms of "is-a" relationships.
- Subtype discriminator
- Inheritance
- Specialization hierarchy
- Entity supertype
Correct Answer

A. Specialization hierarchy

Explanation

The relationships depicted within the specialization hierarchy are sometimes described in terms of "is-a" relationships. In a specialization hierarchy, entities are organized into a hierarchy based on their specific characteristics or attributes. Each entity in the hierarchy is a specialized version of the entity above it, representing a more specific type or subtype. The "is-a" relationship implies that a specialized entity is a type of the more general entity above it in the hierarchy. Therefore, the correct answer is specialization hierarchy.

Rate this question:
24.

Every subtype can have ____ supertype(s) to which it is directly related.
- Zero
- Only one
- One or many
- Many
Correct Answer

A. Only one

Explanation

Every subtype can have only one supertype to which it is directly related. This means that a subtype can inherit properties and behaviors from only one supertype. This relationship is known as single inheritance, where a subtype can extend or specialize a single supertype. Having multiple supertypes would introduce ambiguity and potential conflicts in the inherited properties and behaviors, which is avoided by allowing only one supertype for each subtype.

Rate this question:
25.

A specialization hierarchy can have ____ level(s) of supertype/subtype relationships.
- Zero
- Only one
- One or many
- Many
Correct Answer

A. Many

Explanation

A specialization hierarchy can have many levels of supertype/subtype relationships. This means that there can be multiple levels of generalization and specialization within the hierarchy, allowing for a more detailed and complex classification system. Each level represents a different level of abstraction and specialization, allowing for more specific categorization of entities within the hierarchy.

Rate this question:
26.

Non-overlapping subtypes are subtypes that contain a(n) ____ subset of the supertype entity set.
- Entity
- Subtypes
- Unique
- Nonunique
Correct Answer

A. Unique

Explanation

Non-overlapping subtypes are subtypes that contain a unique subset of the supertype entity set. This means that each entity in the supertype can only belong to one subtype, and there is no overlap or duplication of entities between the subtypes. This ensures that each entity is uniquely categorized and avoids any ambiguity or confusion in the classification process.

Rate this question:

1
27.

In the specialization hierarchy there is a ____ relationship between a subtype and supertype.
- Self-referring
- 1:1
- 1:M
- M:N
Correct Answer

A. 1:1

Explanation

In the specialization hierarchy, a 1:1 relationship exists between a subtype and supertype. This means that for every instance of the supertype, there is only one corresponding instance of the subtype, and vice versa. It implies a unique and direct relationship between the two entities, where each instance of the supertype is associated with exactly one instance of the subtype, and vice versa.

Rate this question:
28.

One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype.
- Primary
- Natural
- Foreign
- Surrogate
Correct Answer

A. Primary

Explanation

All entity subtypes inherit their primary key attribute from their supertype. This means that the primary key attribute of the supertype is passed down to all its subtypes, ensuring that each subtype has a unique identifier. This inheritance characteristic helps maintain data integrity and allows for efficient data retrieval and manipulation in a database system.

Rate this question:
29.

The default comparison condition for the subtype discriminator attribute is the ____ comparison.
- Not equality
- Less than
- Greater than
- Equality
Correct Answer

A. Equality

Explanation

The default comparison condition for the subtype discriminator attribute is equality. This means that the subtype discriminator attribute is compared for equality with the specified values to determine the subtype of an entity.

Rate this question:
30.

A(n) ____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.
- Subtype discriminator
- Inheritance discriminator
- Specialization hierarchy
- Entity supertype
Correct Answer

A. Subtype discriminator

Explanation

A subtype discriminator is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related. This attribute is used to identify and differentiate between the various subtypes within the supertype entity. It helps in categorizing and organizing the data in the database based on specific characteristics or properties of the subtypes.

Rate this question:
31.

The property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.
- Subtype discriminator
- Inheritance
- Specialization hierarchy
- Entity supertype
Correct Answer

A. Inheritance

Explanation

Inheritance is the property that allows an entity subtype to inherit the attributes and relationships of the supertype. This means that the subtype can access and use the same attributes and relationships as the supertype, without needing to redefine or recreate them. Inheritance is a fundamental concept in object-oriented programming and database design, as it allows for code reuse and the organization of entities into hierarchies based on their common characteristics.

Rate this question:
32.

____ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.
- Specialization
- Generalization
- Partial completeness
- Total completeness
Correct Answer

A. Generalization

Explanation

Generalization is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes. This process involves finding common attributes and behaviors among the subtypes and creating a generalized supertype that encompasses these commonalities. This allows for easier management and organization of the entities within a system or database.

Rate this question:
33.

If one exists, a data modeler uses a ____ as the primary key of the entity being modeled.
- Foreign key
- Combination key
- Surrogate key
- Natural identifier
Correct Answer

A. Natural identifier

Explanation

A data modeler uses a natural identifier as the primary key of the entity being modeled. A natural identifier is a unique attribute or combination of attributes that already exists within the entity and can be used to uniquely identify each instance of the entity. This can be a real-world identifier such as a social security number or a unique attribute within the entity itself like an employee ID. Using a natural identifier as the primary key helps maintain data integrity and ensures that each entity instance can be uniquely identified.

Rate this question:
34.

An entity cluster is formed by combining multiple interrelated entities into ____.
- A single abstract entity object
- Multiple abstract entity object
- A single entity object
- Multiple entity objects
Correct Answer

A. A single abstract entity object

Explanation

An entity cluster is formed by combining multiple interrelated entities into a single abstract entity object. This means that instead of having separate entity objects for each individual entity, they are merged together to create a unified and abstract representation. This allows for easier management and manipulation of the entities as they can be treated as a single unit.

Rate this question:
35.

Overlapping subtypes are subtypes that contain ____ subsets of the supertype entity set.
- Entity
- Subtypes
- Unique
- Nonunique
Correct Answer

A. Nonunique

Explanation

Overlapping subtypes are subtypes that contain nonunique subsets of the supertype entity set. This means that multiple subtypes can have the same entities, resulting in overlapping subsets. In other words, an entity can belong to more than one subtype within the supertype entity set. This allows for more flexibility and complexity in the classification of entities within the system.

Rate this question:
36.

A ____ key is a real-world, generally accepted identifier used to distinguish that is, uniquely identify-real-world objects.
- Primary
- Natural
- Foreign
- Surrogate
Correct Answer

A. Natural

Explanation

A natural key is a real-world, generally accepted identifier used to distinguish and uniquely identify real-world objects. Natural keys are typically inherent to the object being identified and are not artificially created or assigned. They can be attributes or combinations of attributes that already exist in the real world and have a unique value for each object. Examples of natural keys include social security numbers, email addresses, or vehicle identification numbers. These keys are considered reliable and stable identifiers as they are unlikely to change over time.

Rate this question:
37.

The most important characteristic of an entity is its ____ key, used to uniquely identify each entity instance.
- Primary
- Natural
- Foreign
- Surrogate
Correct Answer

A. Primary

Explanation

The most important characteristic of an entity is its primary key, used to uniquely identify each entity instance. A primary key is a column or a set of columns that uniquely identifies each record in a table. It ensures that each entity instance has a unique identifier, which is crucial for data integrity and relational database design.

Rate this question:
38.

The primary key's main function is to uniquely identify a(n) ____ within a table.
- Attribute
- Entity instance or row
- Entity subtype
- Natural identifier
Correct Answer

A. Entity instance or row

Explanation

The primary key is a unique identifier for each row or entity instance in a table. It ensures that each row or instance is distinct and can be easily referenced. By using the primary key, we can uniquely identify and differentiate one row or instance from another within the table.

Rate this question:
39.

The “____” characteristic of primary key states that: The PK must uniquely identify each entity instance. A primary key must be able to guarantee unique values. It cannot contain nulls.
- Unique values
- Nonintelligent
- Preferably single-attribute
- Security complaint
Correct Answer

A. Unique values

Explanation

The characteristic of primary key that is being referred to in this question is "unique values". This means that a primary key must be able to guarantee that each entity instance will have a unique value for the primary key attribute. This ensures that no two entity instances will have the same primary key value, allowing for easy identification and retrieval of specific entities. Additionally, the primary key cannot contain null values, further enforcing the uniqueness requirement.

Rate this question:
40.

The “____” characteristic of a primary key states that: The selected primary key must not be composed of any attribute(s) that might be considered a security risk or violation. For example, using a Social Security number as a PK in an EMPLOYEE table is not a good idea.
- Unique values
- Nonintelligent
- Preferably single-attribute
- Security complaint
Correct Answer

A. Security complaint

Explanation

The given correct answer, "security complaint," explains that the characteristic of a primary key is that it should not include any attribute(s) that could pose a security risk or violation. This means that using sensitive information like a Social Security number as a primary key in a table, such as the EMPLOYEE table, is not advisable. The primary key should be designed in a way that ensures the security and privacy of the data.

Rate this question:
41.

The “____” characteristic of a primary key states that: The PK should not have embedded semantic meaning. An attribute with embedded semantic meaning is probably better used as a descriptive characteristic of the entity rather than as an identifier.
- Unique values
- Nonintelligent
- Preferably single-attribute
- Security complaint
Correct Answer

A. Nonintelligent

Explanation

The characteristic of a primary key that states it should not have embedded semantic meaning is referred to as "nonintelligent." This means that the primary key should not carry any additional information or meaning beyond its role as a unique identifier for the entity. Instead, attributes with embedded semantic meaning are better suited as descriptive characteristics of the entity rather than as identifiers. Using a nonintelligent primary key helps to maintain data integrity and ensures that the key remains stable and meaningful even if the descriptive attributes change.

Rate this question:
42.

Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the ____ relationship.
- 0:1
- 1:1
- 1:M
- M:N
Correct Answer

A. M:N

Explanation

Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the M:N relationship. In an M:N relationship, multiple instances of one entity can be related to multiple instances of another entity. Therefore, using a composite primary key ensures that each unique combination of primary key values is only allowed once in the relationship, preventing duplicate or redundant data.

Rate this question:
43.

Surrogate primary keys are especially helpful when there is no ____ key.
- Primary
- Natural
- Foreign
- Composite
Correct Answer

A. Natural

Explanation

Surrogate primary keys are especially helpful when there is no natural key. Natural keys are attributes or combinations of attributes that already exist in the data and can uniquely identify a record. However, there are cases where a natural key may not be available or may not be suitable for use as a primary key. In such situations, a surrogate primary key, which is an artificially generated unique identifier, can be used instead. This ensures that each record has a unique identifier, even if there is no natural key present.

Rate this question:
44.

____ keys work with primary keys to properly implement relationships in the relational model.
- Foreign
- Composite
- Natural
- Surrogate
Correct Answer

A. Foreign

Explanation

Foreign keys are used in the relational model to establish relationships between tables. They link a column in one table to the primary key column in another table. This ensures referential integrity and helps maintain the integrity and consistency of the data across related tables.

Rate this question:
45.

The preferred placement for a foreign key when working with a 1:1 relationship is ____.
- Use the same primary key for both entities
- Create a bridge entity
- Place a foreign key in one of the entities
- Place a foreign key in both entities
Correct Answer

A. Place a foreign key in one of the entities

Explanation

When working with a 1:1 relationship, the preferred placement for a foreign key is to place it in one of the entities. This allows for a direct association between the two entities, where one entity references the primary key of the other entity. Placing a foreign key in both entities would create a redundant relationship and is not necessary. Creating a bridge entity is typically used for many-to-many relationships, not for 1:1 relationships. Using the same primary key for both entities is also not preferred as it does not establish a clear relationship between the entities.

Rate this question:
46.

____ data refer to data whose values change over time and for which you must keep a history of the data changes.
- Time-sensitive
- Time-variant
- Historical
- Change-based
Correct Answer

A. Time-variant

Explanation

Time-variant data refers to data whose values change over time and for which you must keep a history of the data changes. This means that the data is not static and can vary over different time periods. It is important to track and record these changes in order to analyze trends, patterns, and make informed decisions based on the historical data.

Rate this question:
47.

A ____ occurs when you have one entity in two 1:M relationships to other entities, thus producing an association among the other entities that are not expressed in the model.
- Surrogate primary keys
- Time-variant data
- Design trap
- Fan trap
Correct Answer

A. Fan trap

Explanation

A fan trap occurs when you have one entity in two 1:M relationships to other entities, thus producing an association among the other entities that are not expressed in the model. This can lead to confusion and incorrect interpretations of the relationships between entities.

Rate this question:
48.

____ relationships occur when there are multiple relationship paths between related entities.
- Redundant
- Duplicated
- Time-variant
- Supertype
Correct Answer

A. Redundant

Explanation

Redundant relationships occur when there are multiple relationship paths between related entities. This means that there are multiple ways to connect the entities, leading to duplication or repetition of information. Redundant relationships can cause data inconsistencies and increase the complexity of the database design. It is important to identify and eliminate redundant relationships to maintain data integrity and improve the efficiency of database operations.

Rate this question:
49.

According to the data modeling checklist, ____ should clearly define participation and cardinality rules.
- Entities
- Naming conventions
- Relationships
- Attributes
Correct Answer

A. Relationships

Explanation

According to the data modeling checklist, relationships should clearly define participation and cardinality rules. This means that relationships between entities in a database should specify how many instances of one entity can be associated with another entity, and whether the association is mandatory or optional. This helps to ensure data integrity and consistency in the database design. Therefore, relationships are an important aspect of data modeling that should be clearly defined.

Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 21, 2023

Quiz Edited by
ProProfs Editorial Team
Dec 17, 2018

Quiz Created by
BOSTON COLLEGE

Database Management Ultimate Quiz!

Entity supertypes and subtypes are organized in a specialization hierarchy.

Quiz Preview

Within a specialization hierarchy, a supertype can exist only within the context of a subtype.

The entity supertype contains the common characteristics and the entity subtypes contain the unique characteristics of each entity subtype.

The property of the subtype discriminator enables an entity supertype to inherit the attributes and relationships of the subtype.

One important inheritance characteristic is that all entity subtypes inherit their primary key attribute from their supertype.

At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a 1:1 relationship.

Entity subtypes do not inherit the relationships in which the supertype entity participates.

In specialization hierarchies with multiple levels of supertype/subtypes, a lower-level supertype inherits all of the attributes and relationships from all of its upper-level subtypes.

An entity supertype can have disjoint or overlapping entity subtypes.

Overlapping subtypes are subtypes that contain a unique subset of the supertype entity set.

Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set.

Implementing non-overlapping subtypes requires the use of one discriminator attribute for each subtype.

The completeness constraint can be partial or total.

Generalization is based on grouping unique characteristics and relationships of the subtypes.

Specialization is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype.

An entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD.

To model time-variant data, you must create a new entity in an M:N relationship with the original entity.

A design trap occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world.

Some designs use redundant relationships as a way to simplify the design.

The extended entity relationship model (EERM) is sometimes referred to as the ____.

____ is a generic entity type that is related to one or more entity subtypes.

The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).

The relationships depicted within the ____ are sometimes described in terms of "is-a" relationships.

Every subtype can have ____ supertype(s) to which it is directly related.

A specialization hierarchy can have ____ level(s) of supertype/subtype relationships.

Non-overlapping subtypes are subtypes that contain a(n) ____ subset of the supertype entity set.

In the specialization hierarchy there is a ____ relationship between a subtype and supertype.

One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype.

The default comparison condition for the subtype discriminator attribute is the ____ comparison.

A(n) ____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.

The property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.

____ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.

If one exists, a data modeler uses a ____ as the primary key of the entity being modeled.

An entity cluster is formed by combining multiple interrelated entities into ____.

Overlapping subtypes are subtypes that contain ____ subsets of the supertype entity set.

A ____ key is a real-world, generally accepted identifier used to distinguish that is, uniquely identify-real-world objects.

The most important characteristic of an entity is its ____ key, used to uniquely identify each entity instance.

The primary key's main function is to uniquely identify a(n) ____ within a table.

The “____” characteristic of primary key states that: The PK must uniquely identify each entity instance. A primary key must be able to guarantee unique values. It cannot contain nulls.

The “____” characteristic of a primary key states that: The selected primary key must not be composed of any attribute(s) that might be considered a security risk or violation. For example, using a Social Security number as a PK in an EMPLOYEE table is not a good idea.

The “____” characteristic of a primary key states that: The PK should not have embedded semantic meaning. An attribute with embedded semantic meaning is probably better used as a descriptive characteristic of the entity rather than as an identifier.

Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the ____ relationship.

Surrogate primary keys are especially helpful when there is no ____ key.

____ keys work with primary keys to properly implement relationships in the relational model.

The preferred placement for a foreign key when working with a 1:1 relationship is ____.

____ data refer to data whose values change over time and for which you must keep a history of the data changes.

A ____ occurs when you have one entity in two 1:M relationships to other entities, thus producing an association among the other entities that are not expressed in the model.

____ relationships occur when there are multiple relationship paths between related entities.

According to the data modeling checklist, ____ should clearly define participation and cardinality rules.