Multiple choice technology databases

If a key from a parent entity migrates into the primary key of the child entity, what type of relationship is formed?

  1. Non-identifying

  2. Normalizing

  3. Categorizing

  4. Identifying

  5. Emphasizing
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When a parent's primary key becomes part of the child's primary key, the child is existence-dependent on the parent, creating an identifying relationship. The child cannot exist without its parent. Non-identifying relationships use foreign keys that aren't part of the child's primary key. 'Normalizing', 'categorizing', and 'emphasizing' are not relationship types.

Keep practicing — related questions