[Year 12 SofDev] Data dictionary - data formats

[Andrew Shortell]

Hi Gordon
Just by the way  - northern territory postcodes start with a zero .. Thus
cannot store postcode as number

Andrew

Andrew Shortell

mailto:shortell at get2me.net
Heidelberg Teaching Unit
Ph 9470 3403
Fax  9470 3215


On 6/04/11 10:22 AM, "Poultney, Gordon A"
<Poultney.Gordon.A at edumail.vic.gov.au> wrote:

> 
> hi Heath et al,
> 
> How about a table something like this for a dd?
> 
> name
> 
> type
> 
> purpose
> 
> acceptable values
> 
> default value
> 
> other
> 
> postcode
> 
> integer
> 
> Customer postcode for use in addressing
> 
> 4 digit
> 
> 1000-9999
> 
> 3400
> 
> can not be blank
> 
> 
> You may wish to store postcode as string instead. Under 'purpose' you may
> relate to (DFD) processes where it is used.
> 
> cheers
>              Gordon
> 
> ----------------
> Gordon Poultney
> Horsham College
> 
> ________________________________
> 
> From: sofdev-bounces at edulists.com.au on behalf of Matheson, Heath A
> Sent: Tue 5/4/11 17:32
> To: Year 12 Software Development Teachers' Mailing List
> Subject: [Year 12 SofDev] Data dictionary - data formats
> 
> 
> 
> Heya All,
> 
> 
> 
> In the outcome 2 detailed example in the study design, "students will design a
> data dictionary that shows the required data items, a description of their
> purpose, their format, their size and their data type".
> 
> 
> 
> What goes in the format field? Is it the data structure? Is it a range or
> acceptable values?
> 
> 
> 
> I'm just not quite sure.
> 
> 
> 
> Have a safe and happy holidays, hope you get lots of eggs and easter buns!
> 
> 
> 
> Heath Matheson
> 
> Mt Beauty
> 
> Important - 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.
> 
> 
> Important - 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.
> _______________________________________________
> http://www.edulists.com.au - FAQ, Subscribe, Unsubscribe
> IT Software Development Mailing List kindly supported by
> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
> http://www.vcaa.vic.edu.au/vce/studies/infotech/softwaredevel3-4.html
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
> Association Inc

-- 
--