🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: ER to Tables: all 15 questions

Quiz: ER to Tables · Question 8 of 15

A weak entity Dependent is identified by (employee, dependent name). What is its table's primary key?

A weak entity Dependent is identified by (employee, dependent name). What is its table's primary key?

  1. A.dependent name only
  2. B.the owner's key plus the partial key (emp_id, dependent_name)
  3. C.a random number
  4. D.emp_id only
Answer & explanation

Correct answer: the owner's key plus the partial key (emp_id, dependent_name)

A weak entity borrows its owner's key and adds its own partial key.

Can you get the rest right without peeking?

Take the timed Quiz: ER to Tables quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →