adplus-dvertising
frame-decoration

Question

When mapping a supertype/subtype relationship which of the following is true?

a.

The supertype primary key is assigned to each subtype.

b.

The subtype primary key is assigned to each supertype.

c.

There is no link between the supertype/subtype entities.

d.

There is no primary key/foreign key relationship between a supertype/subtype.

Posted under Relational Databases DBMS

Answer: (a).The supertype primary key is assigned to each subtype.

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. When mapping a supertype/subtype relationship which of the following is true?

Similar Questions

Discover Related MCQs

Q. If no multivalued attributes exist in a relation, then the relation is in what normal form?

Q. If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?

Q. A transitive dependency is which of the following?

Q. What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?

Q. If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?

Q. Which of the following is an advantage of partitioning?

Q. Sequential retrieval on a primary key for sequential file storage has which of the following features?

Q. A rule of thumb for choosing indexes for a relational database includes which of the following?

Q. Which of the following are integrity controls that a DBMS may support?

Q. A secondary key is which of the following?

Q. The fastest read/write time and most efficient data storage of any disk array type is:

Q. Which of the following improves a query's processing time?

Q. The blocking factor is:

Q. Which of the following is not a relational database?

Q. A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be

Q. A number of related records that are treated as a unit is called

Q. If you want to group the records in the abc database, you could use the Jobcode as the _____.

Q. Which of the following is not characteristic of a relational database model?

Q. A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.

Q. A compound key