adplus-dvertising
frame-decoration

Question

Use of a supertype/subtype relationship is necessary when which of the following exists?

a.

An instance of a subtype participates in a relationship that is unique to that subtype.

b.

An instance of a subtype participates in a relationship that is the same as the other subtypes.

c.

Attributes apply to all of the instances of an entity type.

d.

No attributes apply to any of the instances of an entity type.

Posted under DBMS

Answer: (a).An instance of a subtype participates in a relationship that is unique to that subtype.

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Use of a supertype/subtype relationship is necessary when which of the following exists?

Similar Questions

Discover Related MCQs

Q. When an entity instance must be a member of only one subtype, it is which of the following?

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?

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: