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.
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...!