Data Dictionaries
Course Content Specification
Course Content Specification
Describe and exemplify a data dictionary with three or more entities:
entity name
attribute name
primary and foreign key
attribute type:
text
number
date
time
Boolean
attribute size
validation:
presence check
restricted choice
field length
range
Nat 5 Recap - Data dictionary
Nat 5 Recap - Data dictionary
There is no new content for a data dictionary at Higher. There is a N5 recap here With the only differences being that there will usually be at least three tables and potentially using a compound key.
Once you have modelled your relational database you need to create a data dictionary to describe the structure of your database.
A data dictionary should include:
Entity name
Attributes
Attribute Type
Text/Number/Date/Time/Boolean
Attribute Size
Keys
Validation
Presence/Restricted choice/Length check/Range check
Sample Data Dictionary
Sample Data Dictionary
