Heuristics and normalization are the goals of all databases. Heuristics refers to a trial-and-error method of problem-solving used when an algorithmic approach is impractical. Normalization refers to removing redundancy from a database schema and to have the schema maintain some data integrity without procedural code. The goal of normal forms is to avoid certain data anomalies that can occur in unnormalized tables. In this whitepaper, learn about the rules for table design heuristics for relational models.
Mr. Joe Celko serves as Member of Technical Advisory Board of Cogito, Inc. Mr. Celko joined the ANSI X3H2 Database Standards Committee in 1987 and helped write the ANSI/ISO SQL-89 and SQL-92 standards. He is one of the top SQL experts in the world, writing over 700 articles primarily on SQL and database topics in the computer trade and academic press. The author of six books on databases and SQL, Mr. Celko also contributes his time as a speaker and instructor at universities, trade conferences, and local user groups.