Abstract— Distributed databases have become necessity in
the organizations, as applications are require data locally rather
than remote locations. It is important to place data where the
applications are required to process data. Data fragmentation
and placement becomes a critical performance issue in
Distributed Database design that has to be placed at different
sites based on the usage of data. The performance of the
application would become assessed and improved if it is properly
fragment and allocate data during early design stages. In this
paper, we proposed an algorithm by performing vertical
fragmentation technique for the Distributed Database design for
assessing the performance during early design stages. We
simulated the algorithm with the case study. We used the
proposed algorithm, Attribute Usage Matrix, and Random
Number Generation technique for generating the values of
Request Query, Arrival of Request, and Query generation. The
Simulation results which helps the DBA to assess the
performance of the proposed Distributed Database Design. The
tool which helps the DBA to select the optimum design.