<html 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" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Arial Black";
panose-1:2 11 10 4 2 1 2 2 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";
mso-believe-normal-left:yes;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><![if mso 9]><style>p.MsoNormal
{margin-left:3.0pt;}
</style><![endif]><!--[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" link="blue" vlink="purple" style="margin-left:3.0pt;margin-top:3.0pt;margin-right:3.0pt;margin-bottom:.75pt">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi all,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I’ve pulled out a discussion point we had at the end of the year about the differences between ‘data structure diagrams’ and ‘ER diagram’, needed for Outcome
2<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">And as Mark K rightly pointed out during this discuaaion there does not seem to be a ‘standard’ as such, and I have resorted to ‘Wikipedia’ as the source of
knowledge. I have even gone back to old Uni books with no luck. Lots of talk on ‘data modelling’ and then using ER diagrams to do it but trying to find a definition as such to start putting some notes together.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Has anyone been able to source something or are we going with a data structure diagram that ‘highly resembles’ an ER diagram? Because ER diagram are one data
structure diagram method, I think.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I did find this mind map as I was searching this evening, which visually at least cleared a few things up (if it is in fact an accurate mind map) (note: each
of the green arrow will make that term the centre of the mind map)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><a href="http://en.domotica.net/Data_structure_diagram">http://en.domotica.net//Data_structure_diagram</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><img border="0" width="564" height="318" id="Picture_x0020_1" src="cid:image003.jpg@01CBDDCF.CBAFDCA0"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-right:3.0pt"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Regards<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-right:3.0pt"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Claudia<o:p></o:p></span></p>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:7.5pt;font-family:"Arial Black","sans-serif";color:maroon">*********************************************************************</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:7.5pt;font-family:"Arial Black","sans-serif";color:maroon">Claudia Graham</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:7.5pt;font-family:"Arial Black","sans-serif";color:maroon">VCE Coordinator</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:7.5pt;font-family:"Arial Black","sans-serif";color:maroon">9334 0049 (direct)</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> sofdev-bounces@edulists.com.au
[mailto:sofdev-bounces@edulists.com.au] <b>On Behalf Of </b>Alex Galle<br>
<b>Sent:</b> Thursday, 4 November 2010 4:12 PM<br>
<b>To:</b> 'Year 12 Software Development Teachers' Mailing List'<br>
<b>Subject:</b> Re: [Year 12 SofDev] ER diagrams v data structure diagrams for 2011<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi All<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Going back into a past life an ER diagram was simply created to establish the entities and relationships that exist in what would become a relational database.
No detail was required with respect to each entity other than a name. The DSD on the other hand identified all of the fields within each entity, the key field/fields. The relationships were indentified as being one to one, one to many etc ensuring that the
model created was indeed relational and that a working RDB could be created.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I will go through my old resources to see if what I used is still available. If successful I will pass the details on to the list.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Alex Galle<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> sofdev-bounces@edulists.com.au
[mailto:sofdev-bounces@edulists.com.au] <b>On Behalf Of </b>Margaret Iaquinto<br>
<b>Sent:</b> Thursday, 4 November 2010 11:39 AM<br>
<b>To:</b> sofdev@edulists.com.au<br>
<b>Subject:</b> [Year 12 SofDev] ER diagrams v data structure diagrams for 2011<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif"">In the study design for 2011, a KK includes data structure diagrams and ER diagrams. Looking on the Web for some help, it appears
they are similar and perform similar functions. Perhaps the ER diagram is a subset of the data structure diagram. Haven't fully grasped this yet.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif"">ER diagrams are found in ITA in 2011.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif"">So, can someone supply a way to differentiate the two? Or even websites for examples?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif"">thanks<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif"">Maggie<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><strong><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif"">Margaret Iaquinto</span></strong><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif"">Information Technology Coordinator<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif"">St Leonard's College<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif"">Brighton Campus<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif"">t (+61 3) 9909 9300<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif"">x 529<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""><a href="http://www.stleonards.vic.edu.au/">www.stleonards.vic.edu.au</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""><img border="0" width="160" height="48" id="_x0000_i1025" src="cid:image001.png@01CBDDCE.45F7A490"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif""> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:"Segoe UI","sans-serif"">Alternate email:
<a href="mailto:maggie@iaquinto.net">maggie@iaquinto.net</a><o:p></o:p></span></p>
</div>
<p><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>
<hr>
<p><font color="#000000" face="Arial, Helvetica, sans-serif"><span style="">A dual campus, coeducational Prep to Year 12 school. Delivering consistently high academic results in Melbourne's North West for over 24 years.</span></font></p>
<p><font color="#000066" size="2" face="Arial, Helvetica, sans-serif"><a href="http://www.overnewton.vic.edu.au">www.overnewton.vic.edu.au</a></font></p>
<p><font color="#7f7f7f" size="2"><strong><font face="Arial, Helvetica, sans-serif">Keilor Campus</font></strong><font face="Arial, Helvetica, sans-serif"> </font></font><font size="2"><font face="Arial, Helvetica, sans-serif"> <strong><font color="#FF0000" size="+2">I</font></strong> 2-30
Overnewton Road Keilor, Victoria, 3036 <strong><font color="#FF0000" size="+2">I</font></strong> <strong><font color="#7f7f7f">T</font></strong> 03 9334 0000 <strong><font color="#FF0000" size="+2">I</font></strong> <strong><font color="#7f7f7f">F</font></strong>
03 9336 1835 <br>
<strong><font color="#7f7f7f">Taylors Lakes Campus</font></strong> <strong><font color="#FF0000" size="+2">I</font></strong> 39 - 57 Robertsons Road Taylors Lakes, Victoria, 3038 <strong><font color="#FF0000" size="+2">I</font></strong> <strong><font color="#7f7f7f">T</font></strong>
03 9334 0000 <strong><font color="#FF0000" size="+2">I</font></strong> <strong><font color="#7f7f7f">F</font></strong> 03 9390 5144
</font></font></p>
<p><font color="#7f7f7f" size="2" face="Arial, Helvetica, sans-serif">2011 College Theme</font><font size="2" face="Arial, Helvetica, sans-serif"> <strong><font color="#FF0000" size="+2">I</font></strong> <strong><em><font size="5" face="Times New Roman, Times, serif">Making
Connections</font></em></strong> <strong><font color="#FF0000" size="+2">I</font></strong>
</font></p>
<p><font size="2"><strong><em>Consider the environment before choosing to print this email.</em>
</strong></font></p>
</body>
</html>