Other Tutorials by

Visual Basic - Visual Basic tutorials

VB6 beginners tutorial - Learn VB6

Advanced VB6 tutorial - Learn Advanced VB6

You are here: > Systems Analysis and Design

Design of Databases and Files

Once the analyst has decided onto the basic processes and inputs and outputs of the system, he also has to decide upon the data to be maintained by the system and for the system. The data is maintained in the form of data stores, which actually comprise of databases.

Each database may further be composed of several files where the data is actually stored. The analyst, during the design of the system, decides onto the various file-relating issues before the actual development of the system starts.

The design of files includes decisions about the nature and content of the file itself such as whether it is to be used for storing transaction details, historical data, or reference information.

Following decisions are made during file design:

  • Which data items to include in a record format within the file?

  • Length of each record, based on the characteristics of the data items

  • The sequencing or arrangement of records within the file (the storage structure, such as sequential, indexed, or relative)

In database design, the analyst decides upon the database model to be implemented.Database model can be traditional file based, relational, network, hierarchical, or object oriented database model. These data models are discussed in detail in lesson 7 on Data Modeling.

Other Design Elements

See Also


<< Previous Page | Contents | Next Page >>


Home | About Us | Privacy Policy | Contact Us

Copyright © | All Rights Reserved