DataBase Design

Creator
Creator
Seonglae ChoSeonglae Cho
Created
Created
2025 May 20 15:54
Editor
Edited
Edited
2025 May 20 15:55
Refs
Refs
  • Principle of Orthogonal Design (POOD): Base relations are independent;
  • Principle of Representational Parsimony (PORP): There are no superfluous base relations;
  • Principle of Expressive Completeness (POEC): All meaningful relations are derivable from the base relations.
  • Principle of Full Normalization (POFN) : Every base relation should be in its highest normal form. Thus eliminating redundancy and preventing anomalies by ensuring that each relation is free from undesirable characteristics like partial, transitive, or join dependencies.
  • The Information Principle (TIP) : All information in the database is represented explicitly and in exactly one way — by attribute values drawn from domains in relations.
  • Principle of Logical Independence (PLI) : Application programs and terminal activities remain logically unimpaired when information preserving changes of any kind that theoretically permit unimpairment are made to the base relations.
 
 
 
 
 

Recommendations