Flashcards
Data Dictionaries
Flashcards do conjunto (11)
- 1What 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. - 2Table NameA unique name for each table in the database.
- 3Table SecurityWho has access to write, update, edit or delete values to or from the table.
- 4KeysPrimary keys are identified
- 5RelationshipsThe relationships between tables are identified - one-to-many etc.
- 6Field NameEach field is identified.
- 7Field Data TypeThe data type given to each field - text/string/date/boolean etc.
- 8Field LengthThe number of characters allocated for the contents of the field.
- 9Field Default ValueIf a field has a default value that automatically appears on the creation of a new record.
- 10Field ValidationAny validation field applied to the field, i.e. drop-down box, look-ups and presence checks.
- 11IndexesAny field that is indexed.
Informações
- Descrição
- FlashCards sobre Data Dictionaries, criado por bethlewis em 06-03-2015.
- Criado por
- bethlewis
- Visualizações
- 26
- Tags
- Avaliação