Adding Validation to the Data Dictionary

Adding Validation to the Data Dictionary

1. Validation Checks: * Presence * Format * Length * Range/Lookup * Table Lookup

2. Look at the validation bullet points and from each one decide which table and fields are having the validation and what type.

3. "Without" - means a presence check "Valid" - means a format check "Between values" - means a range check

4. If a field from another table is mentioned, this indicates that there is a relationship between the tables and will need a TABLE LOOKUP.

5. TABLE LOOKUPS are only applied to FOREIGN KEY fields