I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

July Edition
Subscribe now! It's Free!
Enter your email:

   ► KBDBA Knowledge Base  Print This    Tips Database All Groups  

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.

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.

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech