[Year 12 IT Apps] ITA new design - ITA U301 KK06

[Biggins, Leanne D]

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?
Leanne Biggins
Heathmont College

________________________________

From: itapps-bounces at edulists.com.au on behalf of Mark KELLY
Sent: Sat 27/03/2010 12:38 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] ITA new design. Sorry - another one.


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.

And it can't be solely a database design issue.  

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.  

RI, however, does detect data entries for which there is no foreign key field match and prevents/challenges their entry.

2.2 cents' worth.


On Fri, Mar 26, 2010 at 4:07 PM, Timmer-Arends <timmer at melbpc.org.au> wrote:


	Hello Mark
	 
	'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.
	 
	Regards
	Robert T-A

		----- Original Message ----- 
		From: Mark KELLY <mailto:kel at mckinnonsc.vic.edu.au>  
		To: Year 12 IT Applications Teachers' Mailing List <mailto:itapps at edulists.com.au>  
		Sent: Friday, March 26, 2010 3:02 PM
		Subject: [Year 12 IT Apps] ITA new design. Sorry - another one.

		Apologies for all the posts, but the new design is an interesting beast.
		
		ITA U3O2 Key Knowledge 11 - "ways in which normalisation can ensure the integrity of data in an RDBMS"
		
		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*
		
		
		*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.
		
		-- 
		Mark Kelly
		Manager - Information Systems
		McKinnon Secondary College
		McKinnon Rd McKinnon 3204, Victoria, Australia
		Direct line / Voicemail: 8520 9085
		School Phone +613 8520 9000
		School Fax +613 9578 9253
		kel at mckinnonsc.vic.edu.au
		
		Webmaster - http://www.mckinnonsc.vic.edu.au <http://www.mckinnonsc.vic.edu.au/> 
		IT Lecture notes: http://vceit.com <http://vceit.com/> 
		Moderator: IT Applications Mailing List
		
		
		
		_______________________________________________ 
		http://www.edulists.com.au <http://www.edulists.com.au/> - FAQ, resources, subscribe, unsubscribe 
		IT Applications Mailing List kindly supported by 
		http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html> - Victorian Curriculum and Assessment Authority and 
		http://www.vitta.org.au <http://www.vitta.org.au/> - VITTA Victorian Information Technology Teachers Association Inc

	_______________________________________________ 
	http://www.edulists.com.au <http://www.edulists.com.au/> - FAQ, resources, subscribe, unsubscribe 
	IT Applications Mailing List kindly supported by 
	http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html> - Victorian Curriculum and Assessment Authority and 
	http://www.vitta.org.au <http://www.vitta.org.au/> - VITTA Victorian Information Technology Teachers Association Inc




-- 
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000
School Fax +613 9578 9253
kel at mckinnonsc.vic.edu.au

Webmaster - http://www.mckinnonsc.vic.edu.au <http://www.mckinnonsc.vic.edu.au/> 
IT Lecture notes: http://vceit.com <http://vceit.com/> 
Moderator: IT Applications Mailing List


_______________________________________________ 
http://www.edulists.com.au <http://www.edulists.com.au/> - FAQ, resources, subscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html> - Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au <http://www.vitta.org.au/> - VITTA Victorian Information Technology Teachers Association Inc

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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 7551 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20100329/eeeaeac1/attachment.bin