Database guidelines

Knowing the role of the databases makes a great tool for sorting date. Heres how to create one

1) Determine the purpose of the database

2) Design the tables or files
- Design tables or files on paper first
- Each table or file should contain data about one subject. The member table, for example, contains data about members.

3) Design the records and fields for each table or file.
- Be sure every record has a unquie primary key.
- Use seperate fields for logically distinict items
- Allow enough space for each field
- Set default values for frequently entered data.

4) Determine the relationships amoung the tables or files.