🎙 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 3 of 15

A student can have several phone numbers. What is the right design?

A student can have several phone numbers. What is the right design?

  1. A.Columns phone1, phone2, phone3 in the student table
  2. B.One column with comma-separated numbers
  3. C.A phone column in the course table
  4. D.A separate table (roll_no, phone) with both columns as the primary key
Answer & explanation

Correct answer: A separate table (roll_no, phone) with both columns as the primary key

A multivalued attribute becomes its own table.

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 →