Database Design Guidelines

Database Design Guidelines for Direct Mail Marketing

This is a suggested minimum structure for designing a new database. By separating a recipient’s information into at least this many fields, the information will be manageable and flexible enough for most direct marketing uses.

  • Salutation (Mr/Mrs/Dr)
  • First Name
  • Last Name
  • Suffix (Jr/Sr/III)
  • Job Title
  • Department
  • Company
  • Address Line 1
  • Address Line 2
  • City
  • Province
  • Postal Code
  • Country
  • Phone Number

Example:

Mr. John H. Doe
President
XYZ Company
1234 Main St.
Suite 5
Langley, BC V1A 1A!
Canada
(604) 555-1234