Preview

Data Dictionary

Good Essays
Open Document
Open Document
473 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Data Dictionary
What Is A Data Dictionary?

Per the IBM Dictionary of Computing, a data dictionary is a "centralized repository of information about data such as meaning, relationships to other data, origin, usage, and format." Essentially, it is documentation or data about data in a file or database, also called metadata.

Typical Items In A Data Dictionary
For each field or column in a database table, describe the following elements:

Item
Contents
File/Table Name
The name of the file or table where this field/column is stored (origin)
File/Table Description
A description of the purpose/usage of the file/table.
Field/Column Name

Data Type
Character (Char), numeric (N) including number of decimals, integer (Smallint, Int), memo, binary, varchar, etc.
Position
The starting position of field in record layout (if not in a database table)
Length
Field length
Relationships
If a database table, describe whether column is a Primary (PK) or Secondary Key (SK) to x column in x table.
Meaning
A detailed description of what the data means, including explanations of codes, etc. For example: M = Male, F = Female.
Usage
A detailed description of how the data is used in the system including special processing considerations. For example: “Records with code x must be filtered out to balance to the general ledger total.”
Required/Null
An indication as to whether this field is allowed to have no data (null).

Remember, the meaning and usage of a particular data element may not be exactly what is provided in the system documentation. The users of the system may be storing other data in that field/column for an entirely different purpose. So, be sure to confirm the data meaning and usage with an expert user of the system!

Example Database Data Dictionary
Below is an example of a typical data dictionary obtained from the documentation of a database. This is a good start, but should be enhanced with usage details where applicable to be more useful to end

You May Also Find These Documents Helpful

  • Satisfactory Essays

    The column specification that determines what kind of data can be stored in that column, character versus numeric or date, for example.…

    • 327 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    The data must be adequate, relevant and not excessive to the purpose for which the data are required.…

    • 1120 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Data Base

    • 2312 Words
    • 10 Pages

    While designing and defining tables in databases, it is important to find out the data type for each column in the data tables. A data type is an attribute which defines the type of data an object can retain: integer, string, data and time, etc. There are basically three main types: text, numbers and date/times. The data types are different, depending on the database management system (DBMS), the various types of which include SQL Server, Oracle and MySQL.…

    • 2312 Words
    • 10 Pages
    Good Essays
  • Good Essays

    Anime LIst

    • 11441 Words
    • 52 Pages

    Which of the following fields also serves as a primary key in another table when two tables…

    • 11441 Words
    • 52 Pages
    Good Essays
  • Good Essays

    07

    • 4772 Words
    • 25 Pages

    12) Data values to be added to a table are specified by using the SQL VALUES clause.…

    • 4772 Words
    • 25 Pages
    Good Essays
  • Better Essays

    Data are discreet entities that in of themselves have no meaning. The search for data related…

    • 1053 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    03

    • 4187 Words
    • 33 Pages

    The ALPHANUMERIC datatype can be used to store characters and numbers to a maximum width of 2000.…

    • 4187 Words
    • 33 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Dbm380 Course Syllabus

    • 2296 Words
    • 10 Pages

    Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • • University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum.…

    • 2296 Words
    • 10 Pages
    Satisfactory Essays
  • Good Essays

    Statistics Using Excel

    • 689 Words
    • 3 Pages

    Open the Excel spreadsheet labeled "Example Database." The first page is the Data Dictionary. The…

    • 689 Words
    • 3 Pages
    Good Essays
  • Good Essays

    When you create a table in Datasheet view, you can use the options in the Database group on the Fields tab to add fields to your table.…

    • 585 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Assignment1

    • 354 Words
    • 5 Pages

    What problem would you encounter if you tried to create a listing by last name?…

    • 354 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Week 3

    • 754 Words
    • 4 Pages

    7. A field identified in a table as holding the unique identifier of the table's records is called the (Points : 1)…

    • 754 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    P1 Unit 4 Business Research

    • 2470 Words
    • 10 Pages

    In addition to primary and secondary data, there exists commercial data sold in the form…

    • 2470 Words
    • 10 Pages
    Powerful Essays
  • Powerful Essays

    This exercise will introduce you to the basic building blocks of any database – fields, records, and files (also called tables). Although you will create a database with a single table containing a small amount of data about computer vendors, the more applicable use of databases involves the creation of many tables linked together with a common field or “key.” Regardless of the size of the database, the data is stored in the same way – in fields which are combined to create a record. And those records are stored in a file or table. The data is entered into the field via a data entry form, and the information is extracted (to answer a particular question or need) via reports and/or queries.…

    • 1190 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    ASSig1NEW

    • 808 Words
    • 3 Pages

    It is a range of data, including demographics, medical history, medication and allergies, immunization status, laboratory test results, radiology images, vital signs, personal statistics like age and weight, and billing information…

    • 808 Words
    • 3 Pages
    Good Essays