Database - Data Models into Database Designs

Exercise : Data Models into Database Designs - General Questions
11.
The identifier of an entity will become the ________ of the new table.
foreign key
main attribute
primary key
identity key
Answer: Option
Explanation:
No answer description is available. Let's discuss.

12.
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?
A domain constraint
A range constraint
An intrarelation constraint
An interrelation constraint
Answer: Option
Explanation:
No answer description is available. Let's discuss.

13.
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
primary key.
foreign key.
composite key.
surrogate key.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

14.
Which is not true about surrogate keys?
They are short.
They are fixed.
They have meaning to the user.
They are numeric.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

15.
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Two
Three
Four
Six
Answer: Option
Explanation:
No answer description is available. Let's discuss.