Data Models into Database Designs Questions

• Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
• A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
• For every relationship, how many possible sets of minimum cardinalities are there?
• Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
• A foreign key is:
• For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
• Which of the following column properties specifies whether or not cells in a column must contain a data value?
• 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?
• Which of the following columns is(are) are required in a table?
• Which is not true about surrogate keys?
• 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.
• Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
• 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?
• 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?
• The identifier of an entity will become the ________ of the new table.
• Each entity is represented as a(n):
• Which of the following situation requires the use of ID-dependent entities?
• A primary key should be defined as:
• In a 1:1 relationship, the foreign key is placed in:
• In a 1:N relationship, the foreign key is placed in: