<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.5921" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello Mark</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>'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 face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards</FONT></DIV>
<DIV><FONT face=Arial size=2>Robert T-A</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=kel@mckinnonsc.vic.edu.au
href="mailto:kel@mckinnonsc.vic.edu.au">Mark KELLY</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=itapps@edulists.com.au
href="mailto:itapps@edulists.com.au">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">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 ">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</BLOCKQUOTE></BODY></HTML>