Hi all. I've flipped and flopped over the years about whether I thought data dictionaries were logical or physical design tools. On one page on my Lecture Notes I had them as logical, on another page they were physical. Now I've a sneaking suspicion that <b>both</b> are right: there are logical data dictionaries and physical data dictionaries...<br>
<br>To quote <a href="http://www.modernanalyst.com/Careers/InterviewQuestions/tabid/128/articleType/ArticleView/articleId/1392/categoryId/45/What-is-a-logical-data-dictionary-and-what-are-the-benefits-of-maintaining-one.aspx">http://www.modernanalyst.com/Careers/InterviewQuestions/tabid/128/articleType/ArticleView/articleId/1392/categoryId/45/What-is-a-logical-data-dictionary-and-what-are-the-benefits-of-maintaining-one.aspx</a><br>
<br><i>"At a logical level, the business representative cares about questions such as:<br><br>What is a Sales Contract?<br>What are the primary elements of a Sales Contract?<br>Do these primary elements have attributes or data of their own?<br>
How does a Sales Contract relate to other relevant business entities?<br><br>Once data has been logically defined, the definition and relationships between various pieces of logical data rarely need to change.<br>In contrast, a physical data dictionary allows an organization to describe data in terms of its physical data structure, type, format, and length.<br>
Physical data dictionaries provide programmers of many different systems with a tool to understand how and where the data is stored and how it must be referenced in order to consume it."</i><br><br>Has anyone else discovered these 2 varieties of data dictionaries?<br>
<br>--<br>Mark Kelly<br>Manager Information Systems<br>Reporting Manager<br>IT Learning Area Manager<br><br>McKinnon Secondary College<br>McKinnon Rd McKinnon 3204<br>Victoria, Australia<br>Direct line / Voicemail: +613 8520 9085<br>
Fax +613 9578 9253<br><a href="mailto:kel@mckinnonsc.vic.edu.au">kel@mckinnonsc.vic.edu.au</a><br><br>VCE IT Lecture Notes: <a href="http://vceit.com">http://vceit.com</a><br>Moderator: IT Applications Edulist<br><br>My cow died on this day two years ago. I know because I noted it in my dairy.<br>
<br><br>