Company Name - Project Name - Data Dictionary
Printed On: 4/27/2011 23:05
Version Description
1 First draft
<create a new sheet for each entity and copy the whole of the template sheet to
it - use ctrl-a, ctrl-c, ctrl-v>
<remove text in this style>
<replace text in this style>
Changed By Date
Fred Bloggs 1/1/2000
Company Name - Project Name - Data Dictionary
Printed On: 4/27/2011 23:05
<Entity Name> <describe the meaning of the entity in the problem domain>
Data Member Name Description Type Additional Type Information Defult Value Mandatory? Unique?
<data member name> <describe the meaning of the data Character <specify max and min length <if required> Yes/No Yes/No
member in the problem domain> and any specifically disallowed
characters>
<data member name> <describe the meaning of the data Integer <specify a range if known> <if required> Yes/No Yes/No
member in the problem domain>
<data member name> <describe the meaning of the data Floating <specify max and min values, <if required> Yes/No Yes/No
member in the problem domain> no of decimal points and unit
of measurement>
<data member name> <describe the meaning of the data Enumerated <specify the values that the <if required> Yes/No Yes/No
member in the problem domain> field can take on>
<data member name> <describe the meaning of the data Currency <specify the currency and max <if required> Yes/No Yes/No
member in the problem domain> and min values>
<data member name> <describe the meaning of the data Date <specify the expected <if required> Yes/No Yes/No
member in the problem domain> presention format if there is
one>
<data member name> <describe the meaning of the data Time <specify the expected <if required> Yes/No Yes/No
member in the problem domain> presention format if there is
one>
<data member name> <describe the meaning of the Complex <specify the entity definition <if required> Yes/No Yes/No
complex data member in the within this data dictionary that
problem domain> defines the properties of this
complex type>
<copy and paste lines as required
for new fields>
<create a new sheet for each entity
and copy the whole of the template
sheet to it - use ctrl-a, ctrl-c, ctrl-v>
<remove text in this style>
<replace text in this style>
Hurrys - Store System - Data Dictionary
Printed On: 4/27/2011 23:05
Product An item in the cataloque of products that are available for purchase by a customer
Data Member Name Description Type Additional Type Information
Product Number The unique identifier of the item in Integer 00000000 to 99999999,
the catalogue always 8 digits including
leading zeroes
Description Short description of the product for Character min:1, max:256
customer consumption
Unit Cost The current list price of the product Currency GBP min £0.00 max
£1000000.00
Copyright (C) CRaG Systems 2006
y a customer
Defult Value Mandatory? Unique?
0 Yes Yes
null No No
null Yes No
Company Name - Project Name - Data Dictionary
Printed On: 4/27/2011 23:05
<Entity Name> <describe the meaning of the entity in the problem domain>
Data Member Name Description Type Additional Type Information
<data member name> <describe the meaning of the data Character <specify max and min length
member in the problem domain> and any specifically disallowed
characters>
<data member name> <describe the meaning of the data Integer <specify a range if known>
member in the problem domain>
<data member name> <describe the meaning of the data Floating <specify max and min values,
member in the problem domain> no of decimal points and unit
of measurement>
<data member name> <describe the meaning of the data Enumerated <specify the values that the
member in the problem domain> field can take on>
<data member name> <describe the meaning of the data Currency <specify the currency and max
member in the problem domain> and min values>
<data member name> <describe the meaning of the data Date <specify the expected
member in the problem domain> presention format if there is
one>
<data member name> <describe the meaning of the data Time <specify the expected
member in the problem domain> presention format if there is
one>
<data member name> <describe the meaning of the Complex <specify the entity definition
complex data member in the within this data dictionary that
problem domain> defines the properties of this
complex type>
<copy and paste lines as required
for new fields>
<create a new sheet for each entity
and copy the whole of the template
sheet to it - use ctrl-a, ctrl-c, ctrl-v>
<remove text in this style>
<replace text in this style>
Defult Value Mandatory? Unique?
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
Company Name - Project Name - Data Dictionary
Printed On: 4/27/2011 23:05
<Entity Name> <describe the meaning of the entity in the problem domain>
Data Member Name Description Type Additional Type Information
<data member name> <describe the meaning of the data Character <specify max and min length
member in the problem domain> and any specifically disallowed
characters>
<data member name> <describe the meaning of the data Integer <specify a range if known>
member in the problem domain>
<data member name> <describe the meaning of the data Floating <specify max and min values,
member in the problem domain> no of decimal points and unit
of measurement>
<data member name> <describe the meaning of the data Enumerated <specify the values that the
member in the problem domain> field can take on>
<data member name> <describe the meaning of the data Currency <specify the currency and max
member in the problem domain> and min values>
<data member name> <describe the meaning of the data Date <specify the expected
member in the problem domain> presention format if there is
one>
<data member name> <describe the meaning of the data Time <specify the expected
member in the problem domain> presention format if there is
one>
<data member name> <describe the meaning of the Complex <specify the entity definition
complex data member in the within this data dictionary that
problem domain> defines the properties of this
complex type>
<copy and paste lines as required
for new fields>
<create a new sheet for each entity
and copy the whole of the template
sheet to it - use ctrl-a, ctrl-c, ctrl-v>
<remove text in this style>
<replace text in this style>
Defult Value Mandatory? Unique?
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
<if required> Yes/No Yes/No
