[Year 12 SofDev] RE: Data Dictionary

Russell Quinn QN at boxhillhs.vic.edu.au
Fri Sep 19 14:17:21 EST 2008


I suppose this is what happens when you don't have
a rigorous syllabus statement from VCAA.

I don't take the text books as syllabus statements,
their different treatment of data structures is an excellent
illustration of why not.

Russell Quinn

Mailto: qn at boxhillhs.vic.edu.au



From: sofdev-request at edulists.com.au
Sent: Fri 19/09/2008 12:00 PM
To: sofdev at edulists.com.au
Subject: sofdev Digest, Vol 43, Issue 36


Send sofdev mailing list submissions to
	sofdev at edulists.com.au

To subscribe or unsubscribe via the World Wide Web, visit
	http://www.edulists.com.au/mailman/listinfo/sofdev
or, via email, send a message with subject or body 'help' to
	sofdev-request at edulists.com.au

You can reach the person managing the list at
	sofdev-owner at edulists.com.au

When replying, please edit your Subject line so it is more specific
than "Re: Contents of sofdev digest..."


Today's Topics:

   1. Re: DFD question (Robert Mercer)


----------------------------------------------------------------------

Message: 1
Date: Fri, 19 Sep 2008 10:05:01 +1000
From: "Robert Mercer" <rmercer at groupwise.swin.edu.au>
Subject: Re: [Year 12 SofDev] DFD question
To: "Year 12 Software Development Teachers' Mailing List"
	<sofdev at edulists.com.au>
Message-ID: <48D3794D.C0B5.00B9.0 at groupwise.swin.edu.au>
Content-Type: text/plain; charset=US-ASCII

Thanks everyone, now I can see where the discrepancies come in. I guess as the VCAA exams focus on the use of DFDs in database table designs, that is the point to be emphasised. Along with a general awareness the other possible applications so students. And as about 60% of students got 0/2 for this on the exam, perhaps it is worth revisiting with students.

>>> "Kevork Krozian" <Kroset at novell1.fhc.vic.edu.au> 18/09/2008 12:15 pm >>>
Hi Folks,

 A data dictionary can contain the following :
  1. a data element ( think of a field in a data table )
  2. a data flow as in a data flow diagram
  3. a data store ( think of a file )
  4. a process  ( the round things in DFDs )

  Whilst a data dictionary may be presented that contains only one part of a system ( fields in a table ) , it is not the only type of information found in a data dictionary.
A data dictionary has to be a system development/design tool so how can it only refer to fields in a table? Data in a system is not just a field in a table. 
In addition, a data dictionary needs to be able to be referred to at any stage of the SDLC, not just when database table design takes place.

A number of references refer to this explanation including Fitzpatrick , Keane ( the Thomson book referred to by Rob Mercer  - p 73 , not p25 ) and
  1. Systems Development Analysis, Feasiblity and Implementation by Olekalns ISBN 0=86458-040-1
  2. Systems Development Models by Courtier ISBN 1-875886-50-8
  3. System Documentaion Methods by Judy Adams 
  4. Management Information Systems - concepts, issues, tools and Applications by Tatnall, Davey,Burgess, and Davison ( Data Publishing )1998

  One problem has been that VCAA exams have referred to data dictionaries when describing database table design which is strictly correct. However, data dictionaries are not restricted to this type of use only and as that question in the 2007 exam illustrates, it is important for the students to understand this scope of use of data dictionaries.

 Hope that helps


Best Wishes



Kevork Krozian
IT Manager , Forest Hill College
k.krozian at fhc.vic.edu.au 
http://www.fhc.vic.edu.au 
Mobile: 0419 356 034

>>> Mark Kelly <kel at mckinnonsc.vic.edu.au> 18/09/2008 12:24 pm >>>
Did you mean page 73, or am I using the wrong book?

It's interesting how they explicitly include processes in a data 
dictionary (page 72) - I never have.

I see a data dictionary as a pure and simple table of field names, field 
types, lengths, validation rules perhaps.  Not processes, however: 
that's more for an N-S chart, for example.

Interesting though... might do a bit of digging around in the 'real' IT 
world and see what the conventions are there.

Then again, I really don't like their version of IPO charts on p74.  I 
like IPO to be pure "data / processing / information produced" e.g.

INPUT = Date of birth, Today's date
PROCESSING = (Today-DOB)/365.25
OUTPUT = Age

I really dislike using IPO charts as a uselessly vague version of a 
flowchart e.g. (from page 74)

INPUT = Personal details
PROCESSING = Check details
OUTPUT = Checked details

How pointless is that?

yuk.



Robert Mercer wrote:
> Hello,
> 
> I am looking at the data dictionary on page 25 of the Thomson SD text book and there appears to be process listed "Add New Member". I was of the understanding processes do not get listed in data dictionaries as is indicated by the 2007 exam Section C Question 2 c. Anyone have any thoughts?
> 
> Regards,
>  
> Rob Mercer
> ICT Outreach - Project Officer
> Faculty of Information & Communication Technologies
> Swinburne University of Technology
> PO Box 218
> Hawthorn VIC 3122 Australia
>  
> PH:  +61 3 9214 8768
> FAX :+61 3 9819 0823
> rmercer at swin.edu.au 
> 
> 
> -----
> Swinburne University of Technology
> CRICOS Provider Code: 00111D
> 
> NOTICE
> This e-mail and any attachments are confidential and intended only for the use of the addressee. They may contain information that is privileged or protected by copyright. If you are not the intended recipient, any dissemination, distribution, printing, copying or use is strictly prohibited. The University does not warrant that this e-mail and any attachments are secure and there is also a risk that it may be corrupted in transmission. It is your responsibility to check any attachments for viruses or defects before opening them. If you have received this transmission in error, please contact us on +61 3 9214 8000 and delete it immediately from your system. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment.
> 
> Please consider the environment before printing this email.
> 
> 
> _______________________________________________
> http://www.edulists.com.au 
> IT Software Development Mailing List kindly supported by
> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html  - VITTA Victorian Information Technology Teachers Association Inc
> 
> 
> 


-- 
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 95789253
kel AT mckinnonsc.vic.edu.au

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

A conclusion is the place where you got sick of thinking.

_______________________________________________
http://www.edulists.com.au 
IT Software Development Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html  - VITTA Victorian Information Technology Teachers Association Inc

_______________________________________________
http://www.edulists.com.au 
IT Software Development Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au/vce/studies/infotech/softwaredevel3-4.html  - VITTA Victorian Information Technology Teachers Association Inc

-----
Swinburne University of Technology
CRICOS Provider Code: 00111D

NOTICE
This e-mail and any attachments are confidential and intended only for the use of the addressee. They may contain information that is privileged or protected by copyright. If you are not the intended recipient, any dissemination, distribution, printing, copying or use is strictly prohibited. The University does not warrant that this e-mail and any attachments are secure and there is also a risk that it may be corrupted in transmission. It is your responsibility to check any attachments for viruses or defects before opening them. If you have received this transmission in error, please contact us on +61 3 9214 8000 and delete it immediately from your system. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment.

Please consider the environment before printing this email.




------------------------------

_______________________________________________
sofdev mailing list
sofdev at edulists.com.au
http://www.edulists.com.au/mailman/listinfo/sofdev


End of sofdev Digest, Vol 43, Issue 36
**************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/sofdev/attachments/20080919/955ba530/attachment.html


More information about the sofdev mailing list