Data Dictionary Example

Data dictionaries are developed for all institutional databases. At the discretion of the customer, a data dictionary may be developed for a departmental system. The data dictionary documents the physical implementation - the tables - of a data base.

Physical Element Name	Logical Element Name	Format Type	Format Length	Data Sets	Table	Security Code	Element Definition	Examples of Valid Values
CrsNum	Course Number	Char	3	Student	Class, Student/ Class	P	A number in conjunction with a division code uniquely identifies an instructional course at the University of Michigan	DIV CRS361 125
CrsDes	Course Description	Char	26	Student	Class	P	A textual representation of a course elected by a particular student in specific term
Grade	Grade	Char	1	Student	Student/ Class	S
PrsnFamName	Person Family Name	Char	20	Student	Student	S	The family or last name of a person	Pollard, Tecton