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

Mon Mar 29 15:00:38 EST 2010

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.

I didn't think in that case that they were basically the same thing.  I did
ponder on it, however  ;-)

Thanks for pointing it out.

Regards
Mark

On Mon, Mar 29, 2010 at 1:32 PM, Biggins, Leanne D <
biggins.leanne.d at edumail.vic.gov.au> wrote:

> 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.
> _______________________________________________
> 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/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority and
> 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
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/20100329/6c5ff422/attachment-0001.html