

|
The database design process is comprised of the following steps: Requirements collection and analysis Conceptual database design Choice of a DBMS Data model mapping Physical database design Database system implementation We use the following proven 5-step process to develop database solutions. 1. Initial Consultation At no cost, we 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 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, we'll develop a prototype of the database and go over it with you. 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 performance analysis, we complete and deliver the database solution, along with documentation and training as agreed to in the proposal. |