[Year 12 SofDev] Data dictionary - data formats

[Poultney, Gordon A]

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