[Year 12 SofDev] Data dictionary - data formats

[Poultney, Gordon A]

thanks for that Andrew - i thought i'd changed that.... and

I also stupidly pasted a table that turned into nonsense. See attached screenshot of what i meant!

cheers
      Gordon

----------------
Gordon Poultney
Horsham College



-----Original Message-----
From: sofdev-bounces at edulists.com.au on behalf of Andrew Shortell
Sent: Wed 6/4/11 14:14
To: Year 12 Software Development Teachers' Mailing List
Subject: Re: [Year 12 SofDev] Data dictionary - data formats
 
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

-- 
-- 



_______________________________________________
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



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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 9786 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/sofdev/attachments/20110406/488d0beb/attachment.bin