Standards to create the tables:

  1. The table name should be the same as the logical entity name or should bear some significance to the data stored therein.
  2. The table must have a primary key that uniquely identifies each row.
  3. The column names will be same as logical attribute name.
  4. Columns must be defined as NOT NULL wherever possible.
  5. Table names should be no more than 30 alphanumeric characters.

For Examples creating the tables : AccountMaster , CashBalance , TransactionDetail

Guidelines to create the tables:

  1. Keep table names to around 20 characters. This will prevent the truncation of table name in the naming of other objects that contain the table name as part of the object name. e.g. Indexes
  2. Columns may only be denormalized to improve performance, but this should be very carefully balanced against the additional update that may be required.