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

[Mark KELLY]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20100326/040549f2/attachment.html