The existing hardware and software systems are also studied during the analysis phase. The result of the analysis should be better understanding of the system's functional area, actual and potential problems, and opportunities. End users and the system designers must work together to identify processes and uncover potential problem areas. Such cooperation is vital to defining the appropriate performance objectives by which the new system can be judged. Along with s study of user requirement and existing systems, the analysis phase includes the creation of a logical systems design. The logical design must specify the appropriate conceptual model, input, processes, and expected output requirement. When creating a logical design, the designer might use tools as data flow diagram, hierarchical input process output diagram, and entity relationship diagrams. The database data modeling activities take place to discover all entities and their attitudes and the relationships within database. Defining the logical system also functional description of components for process within the database environment. All data transformation are described and documented.