27. Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
28. When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
29. Surrogate keys have much meaning for users.
30. When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.
31. (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
32. When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
33. When the parent entity is required, a new parent row can always be inserted.
34. For every relationship, there are six possible referential integrity actions.
35. An ideal primary key is short, numeric and seldom changing.
36. 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?
37. In a 1:N relationship, the foreign key is placed in:
38. Which of the following column properties specifies whether or not cells in a column must contain a data value?
39. A primary key should be defined as:
40. Which of the following column properties would be used to specify that cells in a column must contain a monetary value?