State Correct Answer for Following Specialization Hierarchy Database Flashcards

Within a specialization hierarchy, a supertype can exist only within the context of a subtype. Question options:a) Trueb) False

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

The relationships depicted within the specialization hierarchy are sometimes described in terms of “is-a” relationships. Question options:a) Trueb) False

The property of _____ enables an entity subtype to inherit the attributes and relationships of the supertype. Question options:a) inheritanceb) entity supertypec) subtype discriminatord) specialization hierarchy

A subtype contains attributes that are common to all of its supertypes. Question options:a) Trueb) False

A(n) _____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related. Question options:a) subtype discriminatorb) entity supertypec) inheritance discriminatord) specialization hierarchy

The entity supertype contains common characteristics, and the entity subtypes each contain their own unique characteristics. Question options:a) Trueb) False

One important inheritance characteristic is that all entity subtypes inherit their _____ key attribute from their supertype. Question options:a) naturalb) surrogatec) foreignd) primary

Which of the following is a specialization hierarchy disjoint constraint scenario in case of partial completeness? Question options:a) Subtype discriminator can be null.b) Each supertype occurrence is a member of only one subtype.c) Each supertype occurrence is a member of at least one subtype.d) Subtype discriminator cannot be null.

_____ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes. Question options:a) Generalizationb) Specializationc) Total completenessd) Normalization

Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B. Question options:a) ownsb) derives fromc) controlsd) determines

Data redundancy produces _____. Question options:a) efficient storage useb) robust designc) slower lookupsd) data integrity problems

From a structural point of view, 3NF is better than _____. Question options:a) 5NFb) 2NFc) 4NFd) 6NF

Denormalization produces a lower normal form. Question options:a) Trueb) False

Normalization is a very important database design ingredient, and the highest level is always the most desirable. Question options:a) Trueb) False