<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 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
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.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</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-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoPlainText>When I was at Uni doing software design, a data table was
a table which described the data types that are in a database, etc.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>For example:<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0
style='border-collapse:collapse;border:none'>
<tr>
<td width=160 valign=top style='width:119.7pt;border:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Item<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border:solid black 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Data type<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border:solid black 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Length<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border:solid black 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Comments<o:p></o:p></p>
</td>
</tr>
<tr>
<td width=160 valign=top style='width:119.7pt;border:solid black 1.0pt;
border-top:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>ID Code<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Number<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>4<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><o:p> </o:p></p>
</td>
</tr>
<tr>
<td width=160 valign=top style='width:119.7pt;border:solid black 1.0pt;
border-top:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Name<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Text<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Unlimited<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><o:p> </o:p></p>
</td>
</tr>
<tr>
<td width=160 valign=top style='width:119.7pt;border:solid black 1.0pt;
border-top:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Post code<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Number<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>4<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Must start with a ‘3’ if in Victoria<o:p></o:p></p>
</td>
</tr>
<tr>
<td width=160 valign=top style='width:119.7pt;border:solid black 1.0pt;
border-top:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Phone number<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Text<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>8<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Must start with a ‘9’<o:p></o:p></p>
</td>
</tr>
<tr>
<td width=160 valign=top style='width:119.7pt;border:solid black 1.0pt;
border-top:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Suburb<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Text<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Unlimited<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><o:p> </o:p></p>
</td>
</tr>
<tr>
<td width=160 valign=top style='width:119.7pt;border:solid black 1.0pt;
border-top:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Gender<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>Text<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>1<o:p></o:p></p>
</td>
<td width=160 valign=top style='width:119.7pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal>‘M’ for male or ‘F’ for female<o:p></o:p></p>
</td>
</tr>
</table>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Hope this helps.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Kind regards<o:p></o:p></p>
<p class=MsoPlainText> <o:p></o:p></p>
<p class=MsoPlainText>Allan Barnes, CEO<o:p></o:p></p>
<p class=MsoPlainText>Australian Institute of Education and Training<o:p></o:p></p>
<p class=MsoPlainText>P.O. Box 171<o:p></o:p></p>
<p class=MsoPlainText>Brunswick West 3055<o:p></o:p></p>
<p class=MsoPlainText>Ph: (03) 9387 2051<o:p></o:p></p>
<p class=MsoPlainText>FAX: (03) 9387 3470<o:p></o:p></p>
<p class=MsoPlainText>Mobile: 0409 428 221<o:p></o:p></p>
<p class=MsoPlainText>-----Original Message-----<br>
From: itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] On
Behalf Of Kevork Krozian<br>
Sent: Friday, 27 February 2009 1:09 PM<br>
To: Year 12 IT Applications Teachers' Mailing List<br>
Subject: Re: [Year 12 IT Apps] Data tables?<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Hi Mark,<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>I did a search for "data table" in the whole
study design 1 - 4 and here are the hits :<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>IT Apps - SAC 31 KK : design tools
including Input-Process-Output charts, data tables, structure charts, annotated
diagrams/<o:p></o:p></p>
<p class=MsoPlainText>mock-ups, layout diagrams;<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>SD -- SAC 32 KK: methods of
expressing software design using data tables and algorithms, including an
overview<o:p></o:p></p>
<p class=MsoPlainText>of flow charts, pseudocode, Nassi-Shneiderman diagrams,
object descriptions and a detailed<o:p></o:p></p>
<p class=MsoPlainText>understanding of one of them;<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>SD -- SAC 32 KSkills :
interpret the design specifications by representing processes in the form of
algorithms and data<o:p></o:p></p>
<p class=MsoPlainText>structures in the form of a data table;<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>SD -- SAC 41 KSkills :
represent specifications in the form of algorithms and data tables;<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText> Based on this I think the meaning is the design of
a database file of which there may be one or more tables ( eg. relational
database ). . Note, " ... representing processes in the form of
algorithms and data structures in the form of a data table;" <o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText> I think the meaning is of a design tool in which a
calculated field would not be shown as it is considered to be one that can be
done by the processor in a query rather than stored in a table. While
calculated fields can be stored, the conventional wisdom is that they are not
efficient when used in a field, but ok in a query or view.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText> <o:p></o:p></p>
<p class=MsoPlainText> Not sure if this helped or confused more.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Kind Regards<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText> <o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Kevork Krozian<o:p></o:p></p>
<p class=MsoPlainText>IT Manager , Forest Hill College<o:p></o:p></p>
<p class=MsoPlainText>k.krozian@fhc.vic.edu.au<o:p></o:p></p>
<p class=MsoPlainText>http://www.fhc.vic.edu.au<o:p></o:p></p>
<p class=MsoPlainText>Mobile: 0419 356 034<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>>>> Mark Kelly <kel@mckinnonsc.vic.edu.au>
27/02/2009 11:46 am >>><o:p></o:p></p>
<p class=MsoPlainText>But Filemaker has calculated fields, which are
formula-based and created <o:p></o:p></p>
<p class=MsoPlainText>and stored with other normal fields in a table. You
can nominate <o:p></o:p></p>
<p class=MsoPlainText>whether you want the calculated field data to be stored
or recalculated <o:p></o:p></p>
<p class=MsoPlainText>as needed.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Matt Trathen wrote:<o:p></o:p></p>
<p class=MsoPlainText>> I think it means that "database tables *should
not* hold<o:p></o:p></p>
<p class=MsoPlainText>> formulas" as data that can be calculated from
other fields would be <o:p></o:p></p>
<p class=MsoPlainText>> redundant.<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> /*Mr Matt Trathen*/<o:p></o:p></p>
<p class=MsoPlainText>> //Maths and ICT Teacher<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> *St Leonard's College*<o:p></o:p></p>
<p class=MsoPlainText>> *Brighton Campus<o:p></o:p></p>
<p class=MsoPlainText>> *163 South Road Brighton East VIC 3187<o:p></o:p></p>
<p class=MsoPlainText>> *t* (+61 3) 99099316<o:p></o:p></p>
<p class=MsoPlainText>> *f* (+61 3) 95923439<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> *www.stleonards.vic.edu.au
<http://www.stleonards.vic.edu.au/>*<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> >>> Mark Kelly
<kel@mckinnonsc.vic.edu.au> 27/02/2009 10:49 >>><o:p></o:p></p>
<p class=MsoPlainText>> You notice something new every day...<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> The ITA study design refers to "KK3.1.12 -
design tools including ...<o:p></o:p></p>
<p class=MsoPlainText>> data tables, structure charts..."<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> Now, I can find data structure tables and data
structure charts in the<o:p></o:p></p>
<p class=MsoPlainText>> texts - but surely 'data tables' are just tables -
with data in them.<o:p></o:p></p>
<p class=MsoPlainText>> Those are not design tools.<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> The Potts text's discussion seems to equate 'data
structure diagrams'<o:p></o:p></p>
<p class=MsoPlainText>> with Entity Relation Diagrams, showing the
relationships between tables<o:p></o:p></p>
<p class=MsoPlainText>> in a database. Fair enough as a design tool.<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> It describes 'data structure tables' like data
dictionaries - defining a<o:p></o:p></p>
<p class=MsoPlainText>> table's field names, types, validation rules
etc. Also fair enough.<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> It also somewhat worryingly says (p43) that
"database tables cannot hold<o:p></o:p></p>
<p class=MsoPlainText>> formulas. Calculations can only be performed in
objects such as queries,<o:p></o:p></p>
<p class=MsoPlainText>> forms and reports" - tell that to a Filemaker
Pro database developer!<o:p></o:p></p>
<p class=MsoPlainText>> Very Access-centric!<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> In brief, do you clever folk reckon the study design
really means data<o:p></o:p></p>
<p class=MsoPlainText>> tables, or is it VCAA secret code for 'data
structure tables'? There's<o:p></o:p></p>
<p class=MsoPlainText>> a pretty big difference.<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> Perhaps Paula can elucidate...<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> -- <o:p></o:p></p>
<p class=MsoPlainText>> Mark Kelly<o:p></o:p></p>
<p class=MsoPlainText>> Manager - Information Systems<o:p></o:p></p>
<p class=MsoPlainText>> McKinnon Secondary College<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>-- <o:p></o:p></p>
<p class=MsoPlainText>Mark Kelly<o:p></o:p></p>
<p class=MsoPlainText>Manager - Information Systems<o:p></o:p></p>
<p class=MsoPlainText>McKinnon Secondary College<o:p></o:p></p>
<p class=MsoPlainText>McKinnon Rd McKinnon 3204, Victoria, Australia<o:p></o:p></p>
<p class=MsoPlainText>Direct line / Voicemail: 8520 9085<o:p></o:p></p>
<p class=MsoPlainText>School Phone +613 8520 9000<o:p></o:p></p>
<p class=MsoPlainText>School Fax +613 9578 9253<o:p></o:p></p>
<p class=MsoPlainText>kel@mckinnonsc.vic.edu.au <o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Webmaster - http://www.mckinnonsc.vic.edu.au <o:p></o:p></p>
<p class=MsoPlainText>IT Lecture notes: http://vceit.com <o:p></o:p></p>
<p class=MsoPlainText>Moderator: IT Applications Mailing List<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>RealMenDon'tNeedSpacebars.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>_______________________________________________<o:p></o:p></p>
<p class=MsoPlainText>http://www.edulists.com.au - FAQ, resources, subscribe,
unsubscribe<o:p></o:p></p>
<p class=MsoPlainText>IT Applications Mailing List kindly supported by<o:p></o:p></p>
<p class=MsoPlainText>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html
- Victorian Curriculum and Assessment Authority and<o:p></o:p></p>
<p class=MsoPlainText>http://www.vitta.org.au - VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>_______________________________________________<o:p></o:p></p>
<p class=MsoPlainText>http://www.edulists.com.au - FAQ, resources, subscribe,
unsubscribe<o:p></o:p></p>
<p class=MsoPlainText>IT Applications Mailing List kindly supported by<o:p></o:p></p>
<p class=MsoPlainText>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html
- Victorian Curriculum and Assessment Authority and<o:p></o:p></p>
<p class=MsoPlainText>http://www.vitta.org.au - VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></p>
<p class=MsoPlainText>-- <o:p></o:p></p>
<p class=MsoPlainText>Message protected by MailGuard: e-mail anti-virus,
anti-spam and content filtering.<o:p></o:p></p>
<p class=MsoPlainText>http://www.mailguard.com.au/mg<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Click here to report this message as spam:<o:p></o:p></p>
<p class=MsoPlainText>https://login.mailguard.com.au/report/1wWXIVsIGi/1tsSt9LozFZ4GCwjjaVJ3H/0.002<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>-- <o:p></o:p></p>
<p class=MsoPlainText>This message has been scanned for viruses and<o:p></o:p></p>
<p class=MsoPlainText>dangerous content by MailScanner, and is<o:p></o:p></p>
<p class=MsoPlainText>believed to be clean.<o:p></o:p></p>
</div>
</body>
</html>