Computer Sciene of Udayana State University

April 5, 2009

Data Dictionary

Filed under: Computer Science — ignaga @ 1:13 AM

Data Dictionary Reports

Many valuable reports

An alphabetized list of all data elements by name

A report describing each data element and indicating the user or department that is responsible for data entry, updating, or deletion

A report of all data flows and data stores that use a particular data element

Detailed reports showing all characteristics of data elements, records, data flows, processes, or any other selected item stored in the data dictionary

Documenting the Records

Typical characteristics of a record include

Record or data structure name

Definition or description

Alternate name(s)

Attributes

Documenting the Entities

Typical characteristics of an entity include

Entity name

Description

Alternate name(s)

Input data flows

Output data flows


Documenting the Processes

Typical characteristics of a process

Process name or label

Description

Process number

Process description

Documenting the Data Stores

Typical characteristics of a data store are

Data store name or label

Description

Alternate name(s)

Attributes

Volume and frequency

Documenting the Data Flows

The typical attributes are as follows

Data flow name or label

Description

Alternate name(s)

Origin

Destination

Record

Volume and frequency


Documenting the Data Elements

The following attributes usually are recorded and described

Source

Security

Responsible user(s)

Description and comments

Documenting the Data Elements

The following attributes usually are recorded and described

Data element name or label

Alias

Type and length

Default value

Acceptable values – Domain and validity rules

Documenting the Data Elements

You must document every data element in the data dictionary

The objective is the same: to provide clear, comprehensive information about the data and processes that make up the system

A data element, also called a data item or field, is the smallest piece of data that has meaning

Data elements are combined into records, also called data structures

A record is a meaningful combination of related data elements that is included in a data flow or retained in a data store

A data dictionary, or data repository, is a central storehouse of information about the system’s data

An analyst uses the data dictionary to collect, document, and organize specific facts about the system

Also defines and describes all data elements and meaningful combinations of data elements

A data dictionary, or data repository, is a central storehouse of information about the system’s data

An analyst uses the data dictionary to collect, document, and organize specific facts about the system

Also defines and describes all data elements and meaningful combinations of data elements

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: