| Περιγραφή: |
This project provides an Application Development Tool or Computer-Assisted Software Engineering (CASE) product that would support top-level data analysis, relational data analysis and production of the Enhanced Required Data Model using the Structured Systems Analysis and Design Methodology (SSADM).To produce the SSADM System Data Modeler, it is necessary to review SSADM, review database concepts, determine latest commercial CASE products, determine experience of systems developers on CASE products that they use, produce the software design, implement the design, test the software, and print the necessary documentation and users manual.The study arrived at the following conclusions:In the implementation of the project, a good database design is of paramount importance. This is because the recordsets are so interrelated that if not properly designed would cause anomalies. Knowledge of SQL is likewise important especially in accessing information coming from several recordsets. SQL shortened the routines that would have taken several pages of program code.Much time is needed in the design and implementation of the LDS routines. This is because the LDS module not only manipulates the database but also manifests onscreen. Making an object move the way the user wants requires certain mathematical concepts to ensure that the entities and relationships appear in the correct position.For each attribute it is necessary to determine the table where it is a dependent in order to perform table normalization all in one step. In the implementation of the routines that updates the database, creation of measures that would detect and correct possible sources of error before an update helped preserve database integrity. For instance, the use of repeating screens that prompts for a new and valid name until the user inputs an appropriate response helped prevent certain anomalies.One must know the most appropriate programming language to use. In this project, Visual Basic was used because it has a strong support for database ... |