Exercise: Transforming Data Models Into Database Designs

Questions for: Transforming Data Models Into Database Designs

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?
A:
Null status
B:
Data type
C:
Default value
D:
Data constraints
Answer: D
No answer description is available. Let's discuss.
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.
A:
the primary key
B:
any alternate key
C:
a surrogate key
D:
a foreign key
Answer: A
No answer description is available. Let's discuss.
For every relationship, how many possible sets of minimum cardinalities are there?
A:
Two
B:
Three
C:
Four
D:
Six
Answer: C
No answer description is available. Let's discuss.
Each entity is represented as a(n):
A:
tuple.
B:
table.
C:
attribute.
D:
file.
Answer: B
No answer description is available. Let's discuss.
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
A:
MUST COVER
B:
MUST NOT
C:
Both of the above.
D:
None of the above is correct.
Answer: A
No answer description is available. Let's discuss.
Ad Slot (Above Pagination)
Quiz