Guidelines for creating a simple database.

Abstract

The advantage of using a simple flat file program is its simplicity and flexibility. The user has control over screen and report design; creating a database that meets the specific needs of a single department is easy and inexpensive. On the other hand, flat file programs have limitations. The main problem with Q&A is the need to duplicate data in two or more files. Other limitations are a result of the menu-oriented system, which requires compromises in report formatting and other areas. Database management systems are improving rapidly. Relational databases are becoming easier to use and can overcome many of the limitations of a flat file system. Flat file systems are becoming more enhanced and are beginning to look relational. Developing a system using a simple flat file approach allows the novice to identify and use information without conceptualizing a relational structure. Information can be entered and used quickly, with a better understanding of how everything works. Fewer things can go wrong and need fixing. Keeping your systems simple and following our other guidelines will allow you to use the computer as a tool to increase productivity.