Data Dictionaries

bethlewis
Flashcards by bethlewis, updated more than 1 year ago
bethlewis
Created by bethlewis about 6 years ago
6
1

Description

Flashcards on Data Dictionaries, created by bethlewis on 03/06/2015.

Resource summary

Question Answer
What is a data dictionary? 1. They ensure consistent data usage within a relational database. 2. If the data needs to be modified then the data dictionary will give all details about each table and field. 3. Each table within the database will have an associated data dictionary.
Table Name A unique name for each table in the database.
Table Security Who has access to write, update, edit or delete values to or from the table.
Keys Primary keys are identified
Relationships The relationships between tables are identified - one-to-many etc.
Field Name Each field is identified.
Field Data Type The data type given to each field - text/string/date/boolean etc.
Field Length The number of characters allocated for the contents of the field.
Field Default Value If a field has a default value that automatically appears on the creation of a new record.
Field Validation Any validation field applied to the field, i.e. drop-down box, look-ups and presence checks.
Indexes Any field that is indexed.
Show full summary Hide full summary

Similar

How Legislation Affects Computer Users - Cambridge Nationals ICT
Beth Coiley
Cell Structure
megan.radcliffe16
AS Chemistry - Enthalpy Changes
Sarah H-V
Unit 1 flashcards
C R
Exchange surfaces and breathing
megan.radcliffe16
OCR Chemistry - Atoms, Bonds and Groups (Definitions)
GwynsM
F211: Transport in animals keywords and info
Gurdev Manchanda
OCR AS Biology
joshbrown3397
Types and Components of Computer Systems
Jess Peason
GCSE Biology B2 (OCR)
Usman Rauf
Computing Hardware - CPU and Memory
ollietablet123