FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Advanced Data Modeling

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 42

Essay

Review LaterAdd Note

Review Later

What do specialization hierarchies do?

Correct Answer

verified

Entity supertypes and subtypes are organ...

View Answer

Show Answer

Question 43

True/False

Review LaterAdd Note

A subtype contains attributes that are common to all of its supertypes.

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

An entity supertype can have disjoint or overlapping entity subtypes.

completeness means that every supertype occurrence must be a member of at least one subtype.

A weak-entity in a strong identifying relationship with a parent entity is normally used to represent a(n)that is represented in the data model as two separate entities.

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

A(n) occurs when a relationship is improperly or incompletely identified and is therefore represented in a way that is not consistent with the real world.

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 violation.

Differentiate between specialization and generalization.

The function of the primary key is to describe an entity.

Unique values can be better managed when they are ,because the database can use internal routines to implement a counter-style attribute that automatically increments values with the addition of each new row.

From a data modeling point of view,data refer to data whose values change over time and for which one must keep a history of the data changes.

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

Describe an entity cluster.

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

In the context of total completeness,in a(n) ,every supertype occurrence is a member of at least one subtype.

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

One practical advantage of a(n)key is that because it has no intrinsic meaning,values for it can be generated by the DBMS to ensure that unique values are always provided.