adplus-dvertising
frame-decoration

Question

When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?

a.

Disjoint with total specialization

b.

Disjoint with partial specialization

c.

Overlap with total specialization

d.

Overlap with partial specialization

Posted under DBMS

Answer: (c).Overlap with total specialization

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?

Similar Questions

Discover Related MCQs

Q. Which of the following is not one of the three ways to classify an action assertion?

Q. An action assertion must include which of the following?

Q. Which of the following statements concerning business rules is true?

Q. Which one of the following symbols is not used in an ERD?

Q. Specialization is which of the following processes?

Q. A subtype discriminator is which of the following?

Q. A supertype/subtype hierarchy is which of the following?

Q. A supertype/subtype hierarchy has which of the following features?

Q. In a relational schema, each tuple is divided into fields called

Q. A _____ means that one record in a particular record type may be related to more than one record of another record type.

Q. A _____ means that one record in a particular record type is related to only one record of another record type.

Q. The way a particular application views the data from the data base that the application uses is a :

Q. A scheme describes

Q. A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.

Q. Which of the following situation requires the use of ID-dependent entities?

Q. A foreign key is:

Q. Which of the following columns is(are) are required in a table?

Q. In a 1:1 relationship, the foreign key is placed in:

Q. Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?

Q. The identifier of an entity will become the ________ of the new table.