Hi Leanne. Yes, there were some close calls, especially with the recycled/adapted outcomes. It depends how close each KK matched - few were identical, some matched major criteria, some only bore a superficial terminological familiarity.<br>
<br>I didn't think in that case that they were basically the same thing. I did ponder on it, however ;-)<br><br>Thanks for pointing it out.<br><br>Regards<br>Mark<br><br><div class="gmail_quote">On Mon, Mar 29, 2010 at 1:32 PM, Biggins, Leanne D <span dir="ltr"><<a href="mailto:biggins.leanne.d@edumail.vic.gov.au">biggins.leanne.d@edumail.vic.gov.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;">Hi Mark, I've started to look at both the new study design and your excellent comparison of the current and new study designs. You seem to delete the current 3.2.05 - but I wonder - it looks like some elements of virtual teams might be included in the new ITA U301 KK06, which I can't see in your list. What do you think?<br>
Leanne Biggins<br>
Heathmont College<br>
<br>
________________________________<br>
<br>
From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> on behalf of Mark KELLY<br>
Sent: Sat 27/03/2010 12:38 AM<br>
To: Year 12 IT Applications Teachers' Mailing List<br>
Subject: Re: [Year 12 IT Apps] ITA new design. Sorry - another one.<br>
<br>
<br>
Hi Robert. MS Access has the 'enforce referential integrity' tickbox (or so I am led to believe) so RI is somewhat related to software implementation.<br>
<br>
And it can't be solely a database design 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, does 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>
<br>
On Fri, Mar 26, 2010 at 4:07 PM, Timmer-Arends <<a href="mailto:timmer@melbpc.org.au">timmer@melbpc.org.au</a>> wrote:<br>
<br>
<br>
Hello Mark<br>
<br>
'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.<br>
<br>
Regards<br>
Robert T-A<br>
<br>
----- Original Message -----<br>
From: Mark KELLY <mailto:<a href="mailto:kel@mckinnonsc.vic.edu.au">kel@mckinnonsc.vic.edu.au</a>><br>
To: Year 12 IT Applications Teachers' Mailing List <mailto:<a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a>><br>
Sent: Friday, March 26, 2010 3:02 PM<br>
Subject: [Year 12 IT Apps] ITA new design. Sorry - another one.<br>
<br>
Apologies for all the posts, but the new design is an interesting beast.<br>
<br>
ITA U3O2 Key Knowledge 11 - "ways in which normalisation can ensure the integrity of data in an RDBMS"<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>
<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" target="_blank">http://www.mckinnonsc.vic.edu.au</a> <<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> <<a href="http://vceit.com/" target="_blank">http://vceit.com/</a>><br>
Moderator: IT Applications Mailing List<br>
<br>
<br>
<br>
_______________________________________________<br>
<a href="http://www.edulists.com.au" target="_blank">http://www.edulists.com.au</a> <<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/infotechindex.html" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html</a> <<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/itapplications3-4.html</a>> - Victorian Curriculum and Assessment Authority and<br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> <<a href="http://www.vitta.org.au/" target="_blank">http://www.vitta.org.au/</a>> - VITTA Victorian Information Technology Teachers Association Inc<br>
<br>
_______________________________________________<br>
<a href="http://www.edulists.com.au" target="_blank">http://www.edulists.com.au</a> <<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/infotechindex.html" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html</a> <<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/itapplications3-4.html</a>> - Victorian Curriculum and Assessment Authority and<br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> <<a href="http://www.vitta.org.au/" target="_blank">http://www.vitta.org.au/</a>> - VITTA Victorian Information Technology Teachers Association Inc<br>
<br>
<br>
<br>
<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" target="_blank">http://www.mckinnonsc.vic.edu.au</a> <<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> <<a href="http://vceit.com/" target="_blank">http://vceit.com/</a>><br>
Moderator: IT Applications Mailing List<br>
<br>
<br>
_______________________________________________<br>
<a href="http://www.edulists.com.au" target="_blank">http://www.edulists.com.au</a> <<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/infotechindex.html" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html</a> <<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/itapplications3-4.html</a>> - Victorian Curriculum and Assessment Authority and<br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> <<a href="http://www.vitta.org.au/" target="_blank">http://www.vitta.org.au/</a>> - VITTA Victorian Information Technology Teachers Association Inc<br>
<br>
Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.<br>
_______________________________________________<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/itapplications3-4.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</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>