Conclusions

Successful projects are built from thorough requirements. Requirements-gathering for a Web site usually starts with a set of wireframes, which are then pored over by the customer and development team to develop use cases. These use cases document the business logic, site flow, validations and error conditions.

In this case, an FRD and use cases were presented for a stock tracking application. This application requires attention to both site flow concerns and the detailed business logic involved in stock transactions.

After the requirements are complete, an ERD can be developed, which in turn can be used to generate a schema. By using Torque, the schema, represented in XML, can directly create both the SQL source file and a full set of object-mapped classes for all the tables in the schema.