Visual Basic® Style Guide, The

Database Design

The design of your database is as important as the design of your Visual Basic application. Unfortunately, while you as a developer will always play a key role in the construction of your application, there may be times when you have no say in the design or construction of the database with which you will communicate. Many Visual Basic applications present data stored in existing legacy or shared databases. In such cases, your design role may be limited to clearly documenting the components of the database that you will employ within your application.

For those times when the development of a database rests partially or fully on your shoulders, consistency and efficiency in the design of your database are essential. Some limitations ...