You
are here: Freetutes.com
> 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 >>
|