<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2900.3354" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>If you consider Oracle DBMS to be the "real world" then one of the data dictionary "views" called "USER_SOURCE" or "DBA_SOURCE" - depending on your level of access - contains the source code of all procedures and functions.</DIV>
<DIV>However, this just goes to show that nothing is ever clear cut in this discipline - there are just lots of shades of grey.</DIV>
<DIV>I would incline to the view that (to a first approximation) the data dictionary stores only the field (or column) names and their details ... however, if you include validation rules in here then logically that includes what SQL calls "constraints" - which in Oracle are stored in a data dictionary view called "USER_CONSTRAINTS" or "DBA_CONSTRAINTS" (they sat up all night thinking up the name for that view).</DIV>
<DIV> </DIV>
<DIV>Happily I don't have to convey this information to Year 12 students, so I can afford to be flippant.</DIV>
<DIV> </DIV>
<DIV>Cheers - John</DIV>
<DIV> </DIV>
<DIV>
<DIV><FONT face=Tahoma color=#800000 size=2><EM><FONT color=#ff8040><STRONG>Better a semi-colon than to come to a full stop.</STRONG><BR></FONT>John de Figueiredo - 9564 2647</EM></FONT></DIV>
<DIV><FONT face=Tahoma color=#800000 size=2><EM>Technology Services Department<BR>Staff Computer Applications Trainer<BR>Holmesglen Institute of TAFE (VC Administrator)<BR><A href="mailto:johnde@holmesglen.vic.edu.au">johnde@holmesglen.vic.edu.au</A></EM></FONT></DIV><BR><BR>>>> On 18/09/2008 at 12:59 pm, in message <48D1C413.7080105@mckinnonsc.vic.edu.au>, Mark Kelly <kel@mckinnonsc.vic.edu.au> wrote:<BR></DIV>
<DIV style="PADDING-LEFT: 7px; MARGIN: 0px 0px 0px 15px; BORDER-LEFT: #050505 1px solid; BACKGROUND-COLOR: #f3f3f3">Hi Robert. I agree that processes might be useful data, but I'd <BR>maintain they don't belong in a data dictionary any more than my useful <BR>cheese sandwich should be stored in my fish tank.<BR><BR>Robert Mercer wrote:<BR>> Hi Mark,<BR>> <BR>> Yep sorry page 73 near the bottom. I guess I will assume it is an error or at least a convention not used by the VCAA. Although that being said I am not sure what the advantage of leaving processes out of a Data Dictionary is, seems to contain some possibly useful data.<BR>> <BR>>>>> Mark Kelly <kel@mckinnonsc.vic.edu.au> 18/09/2008 12:24 pm >>><BR>> Did you mean page 73, or am I using the wrong book?<BR>> <BR>> It's interesting how they explicitly include processes in a data <BR>> dictionary (page 72) - I never have.<BR>> <BR>> I see a data dictionary as a pure and simple table of field names, field <BR>> types, lengths, validation rules perhaps. Not processes, however: <BR>> that's more for an N-S chart, for example.<BR>> <BR>> Interesting though... might do a bit of digging around in the 'real' IT <BR>> world and see what the conventions are there.<BR>> <BR>> Then again, I really don't like their version of IPO charts on p74. I <BR>> like IPO to be pure "data / processing / information produced" e.g.<BR>> <BR>> INPUT = Date of birth, Today's date<BR>> PROCESSING = (Today-DOB)/365.25<BR>> OUTPUT = Age<BR>> <BR>> I really dislike using IPO charts as a uselessly vague version of a <BR>> flowchart e.g. (from page 74)<BR>> <BR>> INPUT = Personal details<BR>> PROCESSING = Check details<BR>> OUTPUT = Checked details<BR>> <BR>> How pointless is that?<BR>> <BR>> yuk.<BR>> <BR>> <BR>> <BR>> Robert Mercer wrote:<BR>>> Hello,<BR>>><BR>>> 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?<BR>>><BR>>> Regards,<BR>>> <BR>>> Rob Mercer<BR>>> ICT Outreach - Project Officer<BR>>> Faculty of Information & Communication Technologies<BR>>> Swinburne University of Technology<BR>>> PO Box 218<BR>>> Hawthorn VIC 3122 Australia<BR>>> <BR>>> PH: +61 3 9214 8768<BR>>> FAX :+61 3 9819 0823<BR>>> rmercer@swin.edu.au <BR>>><BR>>><BR>>> -----<BR>>> Swinburne University of Technology<BR>>> CRICOS Provider Code: 00111D<BR>>><BR><BR><BR>-- <BR>Mark Kelly<BR>Manager - Information Systems<BR>McKinnon Secondary College<BR>McKinnon Rd McKinnon 3204, Victoria, Australia<BR>Direct line / Voicemail: 8520 9085<BR>School Phone +613 8520 9000<BR>School Fax +613 95789253<BR>kel AT mckinnonsc.vic.edu.au<BR><BR>Webmaster - <A href="http://www.mckinnonsc.vic.edu.au/">http://www.mckinnonsc.vic.edu.au</A><BR>IT Lecture notes: <A href="http://vceit.com/">http://vceit.com</A><BR>Moderator: IT Applications Mailing List<BR><BR>A conclusion is the place where you got sick of thinking.<BR><BR>_______________________________________________<BR><A href="http://www.edulists.com.au/">http://www.edulists.com.au</A><BR>IT Software Development Mailing List kindly supported by<BR><A href="http://www.vcaa.vic.edu.au/">http://www.vcaa.vic.edu.au</A> - Victorian Curriculum and Assessment Authority and<BR><A href="http://www.vitta.org.au/vce/studies/infotech/softwaredevel3">http://www.vitta.org.au/vce/studies/infotech/softwaredevel3</A>-4.html - VITTA Victorian Information Technology Teachers Association Inc<BR>-- <BR>Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.<BR><A href="http://www.mailguard.com.au/mg">http://www.mailguard.com.au/mg</A><BR><BR><BR></DIV><FONT SIZE=3><BR>
<BR>
_____________________________________________________<BR>
This email and any files transmitted with it are confidential and<BR>
intended solely for the use of the individual or entity to whom they<BR>
are addressed. If you have received this email in error please notify<BR>
the email administrator.<BR>
<BR>
Please consider the environment before you print this email.<BR>
<BR>
This footnote also confirms that this email message has been swept by<BR>
MAILsweeper for the presence of computer viruses.<BR>
______________________________________________________<BR>
</FONT>
</BODY></HTML>
<br><hr size=1>Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.<br><a href=http://www.mailguard.com.au/mg>http://www.mailguard.com.au/mg</a><br>
<!-- MailGuard Message ID: 48d1c96c183290 - use this number for reporting -->
<br> <br>