Re:A Simple Guide to Five Normal Forms in Relational Databas...
by novum on Sunday August 01, 2010 @07:56PM
(#1566399)
I usually include some extra details about each entity to imply that each should be its own table.
[ Parent
| on HN ]
Re:A Simple Guide to Five Normal Forms in Relational Databas...
by Groxx on Sunday August 01, 2010 @08:00PM
(#1566406)
Ah, sorry, I left that part vague. I meant 3 tables, not just two. The point I was trying to make was that your correct answer required junction tables; other interviewers' correct answers require _only_ doctorID, because that's all your text required. And still other interviewers dock points for answering "cleverly" and covering both bases.
Without explicit context, how is the interviewee to know which the interviewer wants? They risk a lower review score no matter how they answer.