<!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.6182" name=GENERATOR>
<STYLE>@font-face {
font-family: Calibri;
}
@font-face {
font-family: Kozuka Gothic Pr6N EL;
}
@font-face {
font-family: @Kozuka Gothic Pr6N EL;
}
@font-face {
font-family: Tw Cen MT Condensed;
}
@page WordSection1 {size: 612.0pt 792.0pt; margin: 72.0pt 72.0pt 72.0pt 72.0pt; }
P.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; mso-fareast-language: EN-US
}
LI.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; mso-fareast-language: EN-US
}
DIV.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; mso-fareast-language: EN-US
}
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
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-compose
}
.MsoChpDefault {
FONT-FAMILY: "Calibri","sans-serif"; mso-fareast-language: EN-US; mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
</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 Benn</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm not sure about your 2NF and 3NF because I'm not
sure what 'cost', 'item cost' and 'item' are in relation to the original field
'item cost'.</FONT></DIV>
<DIV><FONT face=Arial size=2>However, as far as I can tell, except for one thing
your first set of data is already in 1NF because no record has a repeating
group; eg two book titles in the 'books purchased' field, or two equivalent
fields such as 'books purchased 1' and 'books purchased 2'.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>What is missing is a primary key that uniquely
identifies each record. As far as I can tell this would mean the primary key
should be: 'name' and 'book purchased'</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>In your 1NF you have split fields which, for this
example, is probably a good idea, but not necessary to form 1NF; and you have
added a 'cust id' field presumably as a primary key, but as pointed out above
this will not uniquely identify a record, unless the intention is that 'cust id'
is unique for each book purchased by each customer. I suspect that this is not
intended so 'book' should also be italicised, indicating that it forms part of
the primary key.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Once set up like this, one recognises that it
is not in 2NF because there are fields that are dependent only on part of the
primary key, thereby leading to the split tables as you have done.</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=POL@wantirnacollege.vic.edu.au
href="mailto:POL@wantirnacollege.vic.edu.au">POLLOCK, Benn(POL)</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=itapps@edulists.com.au
href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, April 26, 2012 2:56
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Year 12 IT Apps] Data
Normalisation</DIV>
<DIV><BR></DIV>
<DIV class=WordSection1>
<P class=MsoNormal>Covering Data Normlisation at the moment. First time I’ve
attempted this/taught this so I would appreciate any feedback you can give.
I’ve attached an excel document with some Data that I gave to the students
to practice with, and I’ve just had a go at it myself – could someone
tell me if It’s correct? Going by everything I’ve read and other examples, it
looks right to me but I could be wrong! Appreciate any feedback.
<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 14pt; COLOR: #c4163f; FONT-FAMILY: 'Tw Cen MT Condensed','sans-serif'; mso-fareast-language: EN-AU">Benn
Pollock<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 14pt; COLOR: #e36c0a; FONT-FAMILY: 'Tw Cen MT Condensed','sans-serif'; mso-fareast-language: EN-AU">Information
Technology Teacher<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 14pt; COLOR: #2a13b5; FONT-FAMILY: 'Tw Cen MT Condensed','sans-serif'; mso-fareast-language: EN-AU">Wantirna
College<o:p></o:p></SPAN></P>
<P class=MsoNormal><U><SPAN
style="FONT-SIZE: 8pt; COLOR: red; FONT-FAMILY: 'Arial','sans-serif'; mso-fareast-language: EN-AU">Ph:</SPAN></U><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: 'Arial','sans-serif'; mso-fareast-language: EN-AU">
</SPAN><SPAN
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'; mso-fareast-language: EN-AU">9801
9700<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><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
<br><BR>http://www.vitta.org.au - VITTA Victorian Information
Technology Teachers Association Inc
<br><BR>http://www.swinburne.edu.au/ict/schools - Swinburne
University</BLOCKQUOTE></BODY></HTML>