This phase typically
commences with the finalization of the features and functionalities
of the application and identification of the various modules and sub-modules
required to accomplish the application objectives.
Based on the above, detailed (second level) process
flowcharts will be developed clearly highlighting the Input-Process-Output
associated with each module and sub-module. The data elements will
then be segregated into various tables and the inter-relationships
amongst the tables will be defined. During the table design process,
the characteristics of each data element in each table will be understood
in terms of uniqueness, dependency with another data element in
same or another table, data type (text / numeric, etc), mandatory/optional,
maximum and minimum values, admissibility of null values, etc. Primary
and Foreign Keys will be defined. The use of triggers and stored
procedures will also be finalized for various fields.Input screens
will be defined with the objective of maximizing user friendliness
and ensuring data integrity.
At the end of the Design Phase,
a) Input
screens will have been designed and agreed upon
b) The major tables to be used in the database, the data elements
to be included in each table and the primary and foreign keys of
various tables will have been determined
|
|
|
 |
|
