<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-AU link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Correct – not all database programs enforce referential
integrity, so it can give rise to invalid data.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Kind regards<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Allan Barnes, CEO<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Australian Institute of Education and Training<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>P.O. Box 171<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Brunswick West 3055<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Melbourne, Victoria<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ph: (03) 9387 2051<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>FAX: (03) 9387 3470<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Mobile: 0409 428 221<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'>From:</span></b><span lang=EN-US
style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Mike Brookes<br>
<b>Sent:</b> Friday, 26 March 2010 3:50 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] ITA new design. Sorry - another one.<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Normalising a database is a process for making the design of
tables more efficient.<br>
<br>
<a href="http://databases.about.com/od/specificproducts/a/normalization.htm">http://databases.about.com/od/specificproducts/a/normalization.htm</a><br>
<br>
Referential integrity is about preventing the user entering a value in a
foreign key field which does not exist in the key field of the table being
looked up.<br>
<br>
If Filemaker does not enforce referential integrity what does it do if it can't
link the two tables?<br>
<br>
Mike Brookes<br>
Chief cook and bottlewasher<br>
Copperfield College<br>
<br>
<br>
On 26/03/2010 3:02 PM, Mark KELLY wrote: <o:p></o:p></p>
<p class=MsoNormal>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>
_______________________________________________ <br>
<a href="http://www.edulists.com.au">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%20">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">http://www.vitta.org.au </a>- VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></p>
<p class=MsoNormal><br>
_______________________________________________ <br>
<a href="http://www.edulists.com.au">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%20">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">http://www.vitta.org.au </a>- VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></p>
<p class=MsoNormal><span style='color:windowtext'><br>
-- <br>
This message has been scanned for viruses and <br>
dangerous content by <a href="http://www.mailscanner.info/"><b>MailScanner</b></a>,
and is <br>
believed to be clean. <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:windowtext'><o:p> </o:p></span></p>
<p><span style='color:windowtext'>Message protected by MailGuard: e-mail
anti-virus, anti-spam and content filtering.<br>
<a href="http://www.mailguard.com.au/mg">http://www.mailguard.com.au/mg</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:windowtext'><br>
<a
href="https://login.mailguard.com.au/report/1zymuJ4RcQ/sVE876gSPiBVDNO7rAAIa/2.002">Report
this message as spam</a> <br>
<o:p></o:p></span></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:windowtext'>No
virus found in this incoming message.<br>
Checked by AVG - www.avg.com<br>
Version: 9.0.791 / Virus Database: 271.1.1/2768 - Release Date: 03/26/10
07:50:00</span><span style='color:windowtext'><o:p></o:p></span></p>
</div>
</body>
</html>