Database Design

Before creating a database, EBT ensures conformity to the naming convention and database standards established by the clients. EBT ensures that the:

  • Database object names will be consistent and descriptive.

  • Table and column naming style will be consistent.

  • Index and constraints naming style will be consistent.

  • Standards will be developed for the location of source code, scripts, binaries (if any) and database files.

  • Standards will be developed for where to locate documents such as the data models

  • Access to tables will be granted through synonyms and views

  • Policy will be developed for how to declare primary and foreign keys in the relational database

In designing the database, we determine the size and configuration of the database servers. There are four (4) factors that contribute to calculation of the size of the database server, namely: data volumes, usage complexity, number of simultaneous users, and system availability requirements. We also develop indexing plan and partitioning plan, and adhere to the security configuration of the client. If the client does not have one, we work with them to establish one.