ICT Wiki
Advertisement

Choosing Suitable Field Sizes[]

When you design a database you need to make sure that your field are large or small enough for the type of data you intend to store.

Large Field Sizes[]

The following are examples of fields that might require large field sizes:

  • Addresses
  • Surnames
  • Descriptions

Small Field Sizes[]

The following are examples of fields that might require small field sizes:

  • First names
  • Days of the week
  • House numbers

Fixed Field Sizes[]

Some fields are always the same size, such as:

  • Car registration numbers
  • Phone numbers
Advertisement