Database Development

Database Consulting Methodology

  • Requirements Definition: Quality database design and database application software development is predicated on accurate definitions of business process requirements. Whether you are building a smart client desktop application or the latest database-driven website, a clear requirements document is the first step in successful software development life cycle methodology for any qualified database consulting professional.
  • Use Cases: The project requirements document is intended to define the actual deliverables of the project, but it does not contain enough detailed information to be used as a development guideline. The business processes need to be broken down into individual tasks, and requirements and attributes of these tasks need to be defined. This is commonly done through a process called use cases.
  • Database Design: Once the requirements are known and use cases defined, the database design consultant can begin the actual process of building the database model. This involves a database architect assembling all of the required data elements and then defining database tables based upon database normalization rules. Additional design elements include the analysis of appropriate key structures and other integral database schema objects necessary for optimal database performance and reliability.
  • Build Test Requirements: Using the information defined in the requirements, use case and database design processes, the database consultant can build a test plan of required activities. In addition to the final testing, these activities include component and unit test criteria necessary to identify dependencies required in the development plan.
  • Create Development Plan: Now that the project requirements are known, how the users interact with the identified requirements, what the necessary database looks like, and how the resulting product will be tested, the development plan is created. This contains information on the technologies and development standards to be used, the components to be developed, the development steps to be executed and the required sequence of the development events.