← 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?
- A.Columns phone1, phone2, phone3 in the student table
- B.One column with comma-separated numbers
- C.A phone column in the course table
- 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 →