DATA-MANAGEMENT-FOUNDATIONS practice question 11 of 15

Which relationship or association exists between a supertype and its subtype entities?

Full set: 60 questions

Domain Relational Database Fundamentals

Answer options
A: Strong entity
B: IsA relationship Correct answer
C: Associative entity
D: Weak entity
Correct Answer:
B. IsA relationship
Explanation

The relationship between a supertype and its subtype entities is known as an IsA relationship. This term signifies that an instance of a subtype is also an instance of its supertype. For example, a CAR is a VEHICLE. This concept is a core part of generalization and specialization in Enhanced Entity-Relationship (EER) modeling. The supertype contains common attributes, while the subtypes contain specific attributes and inherit all attributes and relationships of the supertype. This hierarchical structure allows for a more organized and efficient data model by reducing redundancy.

Why Incorrect

A. Strong entity: This describes an entity that can exist independently and has its own unique identifier, not a type of relationship.
C. Associative entity: This is a construct used to resolve a many-to-many relationship between two or more entities, not for generalization hierarchies.
D. Weak entity: This describes an entity that is dependent on another (owner) entity for its existence and identification, which is a different concept from specialization. ---

References

1. Elmasri, R., & Navathe, S. B. (2017). Fundamentals of Database Systems (7th ed.). Pearson. In Chapter 8, "The Enhanced Entity-Relationship (EER) Model," Section 8.1, the text states, "The relationship between a superclass and any one of its subclasses is called a superclass/subclass... In many cases, we refer to this relationship by its shorthand name Is-A (or IS-A) relationship." (p. 260).

2. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database System Concepts (7th ed.). McGraw-Hill. In Chapter 7, "Database Design Using the E-R Model," Section 7.8.1 on Specialization explains, "An entity set may include subgroupings of entities that are distinct in some way from other entities in the set... We call this relationship an isa relationship; for example, we say a student is a person." (p. 298).

3. Ullman, J. D., & Widom, J. (n.d.). CS145: Introduction to Databases, Lecture 3: The Entity/Relationship Model. Stanford University. In the lecture slides on "Subclasses," the relationship is defined as: "The relationship between a subclass and its superclass is special: it is an 'isa' relationship."

Scroll to Top