Our approach to database design is similar to the way we approach web development. We combine our experience in business processes, strategic planning, and project management with solid software development techniques to build solutions that actually solve problems or add useful capability. We are particularly proficient at developing and web-enabling Microsoft Access and Microsoft SQL Server databases.
Click here to request more information on database solutions.
We use the following proven 5-step process to develop database solutions.
1. Initial Consultation
At no cost, we travel to your location (or you can come to ours) and discuss your problem or desired new capabilities. We also gain an understanding of platform and software requirements (e.g., Access, FoxPro, SQL Server, etc.), required integration with other systems, and training and documentation requirements. Database functionality should not exist without being cost-effective (we've seen far too many databases that are complete overkill - the cost to maintain it exceeds the benefit it provides ), so our first goal is to understand what you really need so that we propose the right solution.
2. Proposal
Again at no cost, we prepare and submit a detailed, fixed-price proposal. The cost is based on our estimate of the hours it will take to build a database solution that will meet your requirements and exceed your expectations. The proposal will essentially include a functional specification of the database
design. We are available to answer any questions you have about the proposal and will modify it as necessary to incorporate new information.
3. Scoping Meeting (Optional)
Depending on the complexity of the proposed database solution, we may need to talk again before we actually start
designing the database. If the database solution is relatively simple and straightforward, this step may not be necessary. However, we may need more detailed information (e.g., data specifications and validations, interface preferences, reporting requirements, etc.) and we would get that information early in the process.
4.
Database Prototype Development
Based on the information from the proposal and the Scoping Meeting, we'll develop a prototype of the database and meet with you again to go over it. The focus here will be on the user interface and the outputs (e.g., reports, downloads, data transfers, etc.). We can also discuss inner workings, such as data structures and programming techniques, if you would like to.
5. Database Completion
Finally, we incorporate the feedback from the prototype meeting and, using appropriate software development techniques such as alpha/beta testing and performance analysis, we complete and deliver the database
solution, along with documentation and training as agreed to in the proposal.