3 ms·
I usually include some extra details about each entity to imply that each should be its own table.
by novum 16y ago
I usually include some extra details about each entity to imply that each should be its own table.
- Groxx 16y agoAh, 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.
- arethuza 16y agoAsking the interviewer for more information? The ability to ask questions is far important than whether anyone can remember the details of database normal forms!