Question 1 of 25
Hints left: 3
Q1
All primary keys are required.
Q2
A foreign key is used to implement relationships between tables.
Q3
For every relationship, how many possible sets of minimum cardinalities are there?
Q4
When the parent entity is required, a new child row can always be inserted.
Q5
For every relationship, there are six possible sets of minimum cardinalities.
Q6
An intersection table is required to represent M:N relationships.
Q7
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.
Q8
Each entity is represented as a(n):
Q9
In 1:N relationships, which entity becomes the parent entity is arbitrary.
Q10
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.
Q11
The identifier of an entity will become the ________ of the new table.
Q12
The DBMS allows surrogate keys to be changed.
Q13
Surrogate keys have much meaning for users.
Q14
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Q15
In a 1:1 relationship, the primary key placement is arbitrary.
Q16
Intersection tables are ID-dependent on both their parent tables.
Q17
The terms alternate key and candidate key mean the same thing.
Q18
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
Q19
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?
Q20
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Q21
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?
Q22
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
Q23
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
Q24
Which is not true about surrogate keys?
Q25
When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.