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

Q. Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?

View solution

Q. Each entity is represented as a(n):

View solution

Q. For every relationship, how many possible sets of minimum cardinalities are there?

View solution

Q. If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

View solution

Q. Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?

View solution

Q. The type of diagram in which the operations are specified on objects is considered as

View solution

Q. Considering the binary relationships, the possible cardinality ratios are

View solution

Q. The attributes that can be arranged into hierarchy are called

View solution