DBA

	DBA Group Home
Get Started Page eMag: DBA Edition Highlights WEEKLYLESSON Week 20 Lesson MYGROUPSETTINGS My Group Settings

	Message Board
-New Activity -Unanswered Threads -Most Active Threads -Most Read Threads

	DBA KB
-New & Updated -Most Read -10 Min Quickstarts -Recent Comments Tech Articles DBA News Errors Library File Library Resource Links DBATIDBITS: All as FlashCards Code Snippets FAQs Tips Terms & Definitions

	DBA Store
PRESTWOODSTORE Store Home Buy DBA Items

	Members Only
MEMBERSONLY DBA Member List Member Only KB Posts DBA Content Stats Random Article Random MB Thread Random Tidbit

Prestwood eMagazine

May Edition

Subscribe now! It's Free!

► KB ► DBA Knowledge Base

Tips Database All Groups Print This

DBA Tips Page

These Tips are contributed by you (our online community members). They are organized by our knowledge base topics. Specifically, by the DBA sub-topics.

Contribute a Tip

2 DBA, Databases, & Data Tips

Group: DBA, Databases, & Data

Topic: DBA & Data

1. Learn the Three Normal Forms in One Sentence
The three normal forms can be summed up in the following phrase: All the fields of a table should relate to the key, the whole key, and nothing but the key.

More Info +Add Comment (2 Comments)

2. Naming Fields: Choose a Context Name
When naming fields/columns in a table, use ONE name for the data in the field. For example, although states are called provinces and other names in other coutries, use one or the other in the database but not both. Use CompanyState, avoid CompanyStateProvince. Use labels in your website or program to switch context.

More Info +Add Comment