Apologies for all the posts, but the new design is an interesting beast.<br><br>ITA U3O2 Key Knowledge 11 - <b>"ways in which normalisation can ensure the integrity of data in an RDBMS"</b><br><br>Assuming they mean "referential integrity", this will be an interesting dotpoint if you're using Filemaker which does not use the concept of referential integrity*<br>
<br><br>*Except as an awkward kludge by using a validation rule ("exists in limited list") and defining the list to include values in a foreign key field.<br clear="all"><br>-- <br>Mark Kelly<br>Manager - Information Systems<br>
McKinnon Secondary College<br>McKinnon Rd McKinnon 3204, Victoria, Australia<br>Direct line / Voicemail: 8520 9085<br>School Phone +613 8520 9000<br>School Fax +613 9578 9253<br><a href="mailto:kel@mckinnonsc.vic.edu.au">kel@mckinnonsc.vic.edu.au</a><br>
<br>Webmaster - <a href="http://www.mckinnonsc.vic.edu.au">http://www.mckinnonsc.vic.edu.au</a><br>IT Lecture notes: <a href="http://vceit.com">http://vceit.com</a><br>Moderator: IT Applications Mailing List<br><br><br>