Hi Robert. MS Access has the 'enforce referential integrity' tickbox (or so I am led to believe) so RI is <i>somewhat</i> related to software implementation.<br><br>And it can't be solely a database <i>design </i>issue. <br>
<br>Setting up 2 related tables - even with a perfect design - will not prevent accidental entry of a value which fails to find a match in a foreign key field. <br><br>RI, however, <i>does</i> detect data entries for which there is no foreign key field match and prevents/challenges their entry.<br>
<br>2.2 cents' worth.<br><br><div class="gmail_quote">On Fri, Mar 26, 2010 at 4:07 PM, Timmer-Arends <span dir="ltr"><<a href="mailto:timmer@melbpc.org.au">timmer@melbpc.org.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div bgcolor="#ffffff">
<div><font size="2" face="Arial">Hello Mark</font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">'normalisation' refers to a process of database
table design that eliminates 'flaws' in a design that could lead to data
integrity problems. It is a software independent process.</font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">Regards</font></div>
<div><font size="2" face="Arial">Robert T-A</font></div>
<blockquote style="padding-right: 0px; padding-left: 5px; margin-left: 5px; border-left: 2px solid rgb(0, 0, 0); margin-right: 0px;"><div><div></div><div class="h5">
<div style="font: 10pt arial;">----- Original Message ----- </div>
<div style="background: none repeat scroll 0% 0% rgb(228, 228, 228); font: 10pt arial;"><b>From:</b>
<a title="kel@mckinnonsc.vic.edu.au" href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank">Mark KELLY</a> </div>
<div style="font: 10pt arial;"><b>To:</b> <a title="itapps@edulists.com.au" href="mailto:itapps@edulists.com.au" target="_blank">Year 12 IT Applications Teachers' Mailing
List</a> </div>
<div style="font: 10pt arial;"><b>Sent:</b> Friday, March 26, 2010 3:02
PM</div>
<div style="font: 10pt arial;"><b>Subject:</b> [Year 12 IT Apps] ITA new
design. Sorry - another one.</div>
<div><br></div>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" target="_blank">kel@mckinnonsc.vic.edu.au</a><br><br>Webmaster
- <a href="http://www.mckinnonsc.vic.edu.au" target="_blank">http://www.mckinnonsc.vic.edu.au</a><br>IT
Lecture notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>Moderator:
IT Applications Mailing
List<br><br><br></div></div><div class="im">_______________________________________________ <br><a href="http://www.edulists.com.au" target="_blank">http://www.edulists.com.au </a>- FAQ,
resources, subscribe, unsubscribe <br>IT Applications Mailing List kindly
supported by <br><a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
</a>- Victorian Curriculum and Assessment Authority and <br><a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au </a>- VITTA Victorian
Information Technology Teachers Association Inc</div></blockquote><div class="im">_______________________________________________
<br>
<a href="http://www.edulists.com.au" target="_blank"> http://www.edulists.com.au </a> - FAQ, resources, subscribe, unsubscribe <br>
IT Applications Mailing List kindly supported by <br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html" target="_blank"> http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html </a> - Victorian Curriculum and Assessment Authority and
<br>
<a href="http://www.vitta.org.au" target="_blank"> http://www.vitta.org.au </a> - VITTA Victorian Information Technology Teachers Association Inc</div></div>
</blockquote></div><br><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>