Database Coding

 

When designing a database, you have to make decisions regarding how best to take some system in the real world and model it in a database. This consists of deciding which tables to create, what columns they will contain, as well as the relationships between the tables. While it would be nice if this process was totally intuitive and obvious, or even better automated, this is simply not the case. A well-designed database takes time and effort to conceive, build and refine.

Relational Database Design Benefits

Efficient data entry, updates and deletions

Efficient data retrieval, summarization and reporting will also be efficient.

A well-formulated database model behaves predictably.

Since much of the information is stored in the database rather than in the application, the database is somewhat self-documenting.

Changes to the database schema are easy to make.

Database Design Tools

Our preferred method is to use PHP with MySQL database methods, but we can also design for ASP should the need arise.