Q. Specialization is which of the following processes?

View solution

Q. A subtype discriminator is which of the following?

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. A scheme describes

View solution

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

View solution

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

View solution

Q. A foreign key is:

View solution

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

View solution

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

View solution

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?

View solution

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

View solution

Q. Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?

View solution

Q. A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):

View solution

Q. Which is not true about surrogate keys?

View solution

Q. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

View solution