[Year 12 IT Apps] ITA new design. Sorry - another one.

[Timmer-Arends]

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 
  To: Year 12 IT Applications Teachers' Mailing List 
  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
  IT Lecture notes: http://vceit.com
  Moderator: IT Applications Mailing List


  _______________________________________________ 
  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 - Victorian Curriculum and Assessment Authority and 
  http://www.vitta.org.au - VITTA Victorian Information Technology Teachers Association Inc
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20100326/a306d8eb/attachment-0001.html