Database - Data Models into Database Designs

Exercise : Data Models into Database Designs - General Questions
6.
Which of the following situation requires the use of ID-dependent entities?
Association relationships only
Multivalued attributes only
Archetype/instance relationships only
All of the above use ID dependent entities
Answer: Option
Explanation:
No answer description is available. Let's discuss.

7.
A foreign key is:
a column containing the primary key of another table.
used to define data types.
used to define null status.
all of the above are above correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

8.
Which of the following columns is(are) are required in a table?
A foreign key
An alternate key
A primary key
A surrogate key.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

9.
In a 1:1 relationship, the foreign key is placed in:
either table without specifying parent and child tables.
the parent table.
the child table.
either the parent table or the child table.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

10.
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?
Null status
Data type
Default value
Data constraints
Answer: Option
Explanation:
No answer description is available. Let's discuss.