[Year 12 IT Apps] Data tables?

[Matt Trathen]

I think it means that "database tables should not hold 
formulas" as data that can be calculated from other fields would be redundant.



  
Mr Matt Trathen
Maths and ICT Teacher

St Leonard's College
Brighton Campus
163 South Road Brighton East  VIC  3187
t (+61 3) 99099316
f (+61 3) 95923439


www.stleonards.vic.edu.au

 



>>> Mark Kelly <kel at mckinnonsc.vic.edu.au> 27/02/2009 10:49 >>>
You notice something new every day...

The ITA study design refers to "KK3.1.12 - design tools including ... 
data tables, structure charts..."

Now, I can find data structure tables and data structure charts in the 
texts - but surely 'data tables' are just tables - with data in them. 
Those are not design tools.

The Potts text's discussion seems to equate 'data structure diagrams' 
with Entity Relation Diagrams, showing the relationships between tables 
in a database.  Fair enough as a design tool.

It describes 'data structure tables' like data dictionaries - defining a 
table's field names, types, validation rules etc.  Also fair enough.

It also somewhat worryingly says (p43) that "database tables cannot hold 
formulas. Calculations can only be performed in objects such as queries, 
forms and reports" - tell that to a Filemaker Pro database developer! 
Very Access-centric!

In brief, do you clever folk reckon the study design really means data 
tables, or is it VCAA secret code for 'data structure tables'?  There's 
a pretty big difference.

Perhaps Paula can elucidate...

-- 
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000
School Fax +613 9578 9253
kel at mckinnonsc.vic.edu.au

Webmaster - http://www.mckinnonsc.vic.edu.au
IT Lecture notes: http://vceit.com
Moderator: IT Applications Mailing List

RealMenDon'tNeedSpacebars.

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc
CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify St Leonard's College immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of St Leonard's College. 
-------------- next part --------------
Skipped content of type multipart/related