Effectiveness of weighted graph of schema to aid the minimization and measurement of schema complexity

Database system is used for access multiple users, prevent loss of data and provide security for access of real life or synthetic data set. The complexity of data requirement increasing day by day; therefore minimization of schema becomes an important role for equi distribution or equalization of two or more problems. We find the effect of normalization and de-normalization on minimization of schema of real life data model as well as synthetic data model. Schema complexity is measured by transmitting schema to a graph with weight or weighted graph. Selected special fundamentals from schema for weight the schema graph are described as major part. Minimization of schema ensures easy to measure the schema complexity. The purpose of this sightsee is to appraisal the effectiveness of weighted graph of schema to minimize as well as to measure the complexity.