Advertisment

Top 10 tips for database design

author-image
CIOL Bureau
Updated On
New Update

Advertisment

BANGALORE, INDIA: Databases can be a great tool to organize information, track statistics and generate reports. Like any tool, however, they must be used correctly.

A badly designed or improperly used database will end up creating problems rather than solving them.

The following 10 tips can help users to ensure that databases can be easily exported and manipulated with the minimum of difficulties.

Advertisment

1. Develop A Prototype

2. Split database structure into multiple tables

3. Use understandable field names

4. Avoid illegal file names

5. Ensure Consistency

6. Avoid blank fields

7. Use standard descriptors for date and time

8. Use currency fields if appropriate

9. Avoid proprietary extensions

10. Avoid the use of field dividers

Click here for more...!

tech-news