<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" 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 12 (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:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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:"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;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.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'>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@01CB7C3A.491DACA0"><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>
</div>
<p></p><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.</p>
</body>
</html>