Author Question: Which of the following is true about representing a weak entity with the relational model? A) If ... (Read 8 times)

pane00 · **on:** Jul 7, 2018

Which of the following is true about representing a weak entity with the relational model?

A) If the weak entity is existence-dependent, the key of the parent must be part of the key of the weak entity.
B) If the strong entity has a minimum cardinality of 1, the key of the weak entity must be part of the strong entity.
C) If the weak entity is ID-dependent, the key of the weak entity must be part of the key of the parent entity.
D) If the weak entity is ID-dependent, the key of the parent entity must be part of the key of the weak entity.
E) If the parent entity is existence-dependent, then the minimum cardinality of the weak entity is zero.

Question 2

Which SQL keyword is used to specify a condition that rows must meet to be included in the results of an SQL SELECT query?

A) SELECT
B) FROM
C) WHERE
D) ORDER BY
E) GROUP BY