<div dir="ltr">A worthy colleague has reminded me that the underlined fields may well be acting as a multi-field primary key for the appointments table!<div><br></div><div>That is technically feasible. Grrr.</div><div><br></div><div>But why would <b>anyone</b> in their right mind create a multiple-field key after all we've learned about 2NF problems?<div><br></div><div>It's just dumb database design! </div><div><br></div><div>I never even <b>consider</b> using multiple-field keys, any more than I would consider checking for gas leaks by striking a match.</div></div><div><br></div><div>All right. I withdraw my complaint about the redundant underlining, and replace it with a complaint about setting a bad example to impressionable young database designers.</div><div><br></div><div>Any depiction of multiple-field keys in exams should be accompanied by compulsory health warnings.</div><div><br></div><div>Regards,</div><div>Mark</div><div><br></div><div><br></div><div class="gmail_extra"><br><div class="gmail_quote">On 22 November 2016 at 12:52, Mark <span dir="ltr"><<a href="mailto:mark@vceit.com" target="_blank">mark@vceit.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Again, apologies if this has been brought up before, but <div><br></div><div>Awwww.....A13 was going SO well. </div><div><br></div><div>It cunningly tested both knowledge of relationships and 3NF in one hit. </div><div><br></div><div>I was <b>just</b> about to award the question a Stamp Of Approval when I noticed something...</div><div><br></div><div><div>Why are AppointmentDate and AppointmentTime fields <b>underlined</b> as if they were keys? The only other underlined fields are keys. </div><div><br></div><div>That is just really sloppy proof-reading that leads to inconsistencies that confuse the poor students. </div><span class="HOEnZb"><font color="#888888"><div><br></div><div>-- <br><div class="m_-6632496849918279432gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><i><br></i></div><div><span style="font-size:12.8px">Mark Kelly</span><br></div><div><br></div><div><a href="mailto:mark@vceit.com" style="font-size:12.8px" target="_blank">mark@vceit.com</a><br></div><div><a href="http://vceit.com" target="_blank">http://vceit.com</a></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div></font></span></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><i><br></i></div><div><span style="font-size:12.8px">Mark Kelly</span><br></div><div><br></div><div><a href="mailto:mark@vceit.com" style="font-size:12.8px" target="_blank">mark@vceit.com</a><br></div><div><a href="http://vceit.com" target="_blank">http://vceit.com</a></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div></div>