Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Data Structure Designs 1
282
Data Type
This defines the type of data that the field can store.
The most common data types include:
- Short Text
- Long Text
- Number
- Date/Time
- Currency
- Yes/No
Field Properties
Field Size
This defines the maximum size value a field can hold.
Commonly used for text & number fields.
- Text - The number of characters the field can store.
- Number - The maximum & minimum value the field can store (and if decimal places can be stored).
In our data dictionary we need list the properties we need to set for each field.
The primary and foreign keys you will identify during your normalisation process.
There are other properties you'll be less aware of.
Format/Input Mask
This ensures data entered matches a pre-defined format.
Common data that uses this include:
- Currency - $, £
- Number - %
- Short Text - Phone, Post Code
- Date/Time - Long date, Short date
Validation
These are rules that ensure the data we enter is sensible & reasonable.
Common checks include:
- Presence - a value must be entered
- Length - text must be between certain number of characters.
- Range - number must be between max/min values
- Lookup - choose from predefined options
KnowItAllNinja.com
Data Structure Designs 1
http://www.knowitallninja.com
Data Dictionaries
The data dictionary is a document that describes the structure of the tables and their fields in our database.
It includes none of the actual data we will be storing in our database, but describes the structure