5e Components Of Data Dictionary ***

Question 0

The field name is one component of the data dictionary.

Identify and describe two other components of a data dictionary associated with fields. (4)

Answer 0

Field length (1) the maximum number of characters allowed (1)
Data Type (1) the type of data that can be entered eg integer/real (1)
Key (1) whether the field is a key primary/secondary/foreign (1)
Duplicates (1) whether the field can contain the same value as another field (1) Validation (1) the type of validation applied to the field (1) presence/length (1)

Question 1

Describe three components of a data dictionary. (6)

Answer 1

Table Name (1) The name of the table unique for each table in the database (1)
Field Name (1) The unique name for each field (1)
Data Type (1) allocated to each field (1) eg text/string/date/Boolean (1)
Field length (1) the number of characters allocated for the contents of each field (1)
Default Values (1) a value that automatically appears on the creation of a new record (1)
Validation (1) drop down lists/look-ups/presence checks (1) Relationships between data (1) Primary and Foreign Keys defined
Permissions (1) who can change data (1)
Table Security (1) Access rights /change/edit/ modify/read only (1)
Indexes (1) Any field that is indexed (1)

Question 2

The identification of keys is one item held in a data dictionary related to a field.
Describe two other items held in a data dictionary related to a field. (4)

Answer 2

default value (1) the starting value for the field (1)
validation (1) length/type etc applied to the field (1)
length (1) maximum length of data allowed (1)
data type (1) real/integer etc – that can be stored in the field (1) [field] name (1) unique name for the field (1)