<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.6058" name=GENERATOR>
<STYLE>@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page WordSection1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Arial","sans-serif"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Arial","sans-serif"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Arial","sans-serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman","serif"; mso-style-priority: 99; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
P.MsoAcetate {
FONT-SIZE: 8pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
LI.MsoAcetate {
FONT-SIZE: 8pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
DIV.MsoAcetate {
FONT-SIZE: 8pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: "Arial","sans-serif"; mso-style-type: personal
}
SPAN.EmailStyle19 {
FONT-WEIGHT: normal; COLOR: windowtext; FONT-STYLE: normal; FONT-FAMILY: "Times New Roman","serif"; mso-style-type: personal-reply
}
SPAN.BalloonTextChar {
FONT-FAMILY: "Tahoma","sans-serif"; mso-style-priority: 99; mso-style-link: "Balloon Text"; mso-style-name: "Balloon Text Char"
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
OL {
MARGIN-BOTTOM: 0cm
}
UL {
MARGIN-BOTTOM: 0cm
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-AU vLink=purple link=blue bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello Mark</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm curious to know what these conflicting sources
are.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I've followed Robert H's link and the page one gets
to doesn't actually define them but does describe a (simplified) process to
get to each NF - and what one gets from the process does conform with NF
defs. The links from this page do go to definitions and they are in agreement
with other sources I have looked at. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Mark K's quote is a definition of 2NF that conforms
to other definitions.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The only difference I can see between various
versions I have read is the degree of mathematical/academic gobbledy-gook
involved.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>1NF, 2NF and 3NF were defined way back in the
seventies and because they were formed from a theoretical basis I don't think
they are going to have changed all that much.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>About the only thing that seems to have changed
greatly is the addition of another three NFs.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I think the issue is a problem with the question,
not with the consistency of the definitions. Decoding the definitions for
consumption by students is of course another matter...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards</FONT></DIV>
<DIV><FONT face=Arial size=2>Robert T-A</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=msc@luther.vic.edu.au href="mailto:msc@luther.vic.edu.au">Mark
Scott</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=itapps@edulists.com.au
href="mailto:itapps@edulists.com.au">Year 12 IT Applications Teachers' Mailing
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, April 01, 2011 2:45
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Year 12 IT Apps] Sample
exam questions andentity-relationship diagrams</DIV>
<DIV><BR></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: 'Times New Roman','serif'">Paula<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: 'Times New Roman','serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: 'Times New Roman','serif'">This is good
stuff but we are still struggling with Question 3c<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: 'Times New Roman','serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: 'Times New Roman','serif'">Any chance of
a VCAA definition of what actually goes in 1NF, 2NF and
3NF.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: 'Times New Roman','serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: 'Times New Roman','serif'">The
definitions are different depending on which “source” you
use.<o:p></o:p></SPAN></P>
<DIV>
<P class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><SPAN
style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 'Times New Roman','serif'">thanks<BR>Mark
Scott<BR>Luther College<o:p></o:p></SPAN></P>
<P class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><SPAN
style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 'Times New Roman','serif'">PS
I suppose we could all wait for the guru (Mark Kelly) to provide an answer.
</SPAN><SPAN
style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Wingdings">J</SPAN><SPAN
style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 'Times New Roman','serif'"><BR><BR><BR><o:p></o:p></SPAN></P>
<P class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><SPAN
style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 'Times New Roman','serif'"><o:p> </o:p></SPAN></P></DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: 'Times New Roman','serif'"><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><B><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">
itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <B>On
Behalf Of </B>Christophersen, Paula P<BR><B>Sent:</B> Friday, 1 April 2011
1:32 PM<BR><B>To:</B> Year 12 IT Applications Teachers' Mailing
List<BR><B>Subject:</B> [Year 12 IT Apps] Sample exam questions and
entity-relationship diagrams<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Dear colleagues<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt">The examination specifications and some sample
questions focusing on new content in the study design are now on the VCAA
website:<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><A
href="http://www.vcaa.vic.edu.au/vcaa/vce/studies/infotech/it-applications/publications/IT-Apps-samp.pdf">http://www.vcaa.vic.edu.au/vcaa/vce/studies/infotech/it-applications/publications/IT-Apps-samp.pdf</A><o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Structurally the examination remains the same – two
sections: Section A multiple choice; Section B short and extended responses.
<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt">I draw your attention to a couple of matters in the
sample questions:<o:p></o:p></SPAN></P>
<P class=MsoNormal
style="MARGIN-LEFT: 93pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo2"><![if !supportLists]><SPAN
lang=EN-US style="FONT-SIZE: 9pt; FONT-FAMILY: Symbol"><SPAN
style="mso-list: Ignore">·<SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></SPAN></SPAN><![endif]><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Question 4 focuses on an entity relationship diagram –
this hopefully clarifies recent concerns that have been
raised.<o:p></o:p></SPAN></P>
<P class=MsoNormal
style="MARGIN-LEFT: 93pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo2"><![if !supportLists]><SPAN
lang=EN-US style="FONT-SIZE: 9pt; FONT-FAMILY: Symbol"><SPAN
style="mso-list: Ignore">·<SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></SPAN></SPAN><![endif]><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Question 7 illustrates one way in which the
examination can deal with the choice of different software in Unit 4, Area of
Study 1. Here a common question is presented, and students select the software
tool to explain their answer.<o:p></o:p></SPAN></P>
<P class=MsoNormal
style="MARGIN-LEFT: 93pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo2"><![if !supportLists]><SPAN
lang=EN-US style="FONT-SIZE: 9pt; FONT-FAMILY: Symbol"><SPAN
style="mso-list: Ignore">·<SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></SPAN></SPAN><![endif]><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Question 9 is an example of an extended response
(worth 8 marks) with prompts to guide answers<o:p></o:p></SPAN></P>
<P class=MsoNormal
style="MARGIN-LEFT: 93pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo2"><![if !supportLists]><SPAN
lang=EN-US style="FONT-SIZE: 9pt; FONT-FAMILY: Symbol"><SPAN
style="mso-list: Ignore">·<SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></SPAN></SPAN><![endif]><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Question 12 is an example of the scope of a question
on RDBMS – the focus can only extent to what is covered in Unit 3. Again it
illustrates an extended response with prompts<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Regards<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Paula<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Paula Christophersen</SPAN><SPAN
lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt">ICT Curriculum Manager</SPAN><SPAN
lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt">VCAA</SPAN><SPAN lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt">41 St Andrews Place</SPAN><SPAN
lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt">EAST MELBOURNE 3002</SPAN><SPAN
lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN lang=EN-US
style="FONT-SIZE: 10pt">(03) 9651 4378</SPAN><SPAN
lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><SPAN
lang=EN-US><o:p> </o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt"><B>Important - </B>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.<o:p></o:p></P></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>http://www.edulists.com.au
- FAQ, resources, subscribe, unsubscribe<BR>IT Applications Mailing List
kindly supported
by<BR>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority
and<BR>http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc</BLOCKQUOTE></BODY></HTML>