Stand-alone custom databases using Access and/or SQL Server ASP. NET development. Link to data held in other databases (Oracle, Informix, Access etc), Outlook. Use SQL Server for larger systems. Web browser front-end if required. Prototypes. Add-on's to other systems. Analysis of existing systems. Maintenance of existing systems. Upsizing to SQL Server
System Analysis and Design
The first step is to identify the solution to a business problem. This vital initial strategy includes determining the scope and feasibility of the project. The goals and objectives of the project are identified. The project charter can be documented.
Next comes the analysis. This involves analysing the existing system and planning the requirements for the new one. It usually involves interviewing users, and creating data-flow, entity and process flow diagrams. A context diagram helps clarify the scope of the project.
System design is the process of mapping business requirements with available technology and budgets. It often involves making trade-offs.
The Functional Specification documents the design of the new system and its cost. The process of producing a specification should iterate between the customer and the developer and ensures both parties are clear as to what is needed. It is a blueprint that can be used by other developers to develop a custom application.
Generally, the approach is to create a prototype quickly and test it with the user. This makes sure the underlying database structure is sound, ensures the development process is on the right track, and lets the user have input into the look and feel of the application.
Changes to the original specification can be made early, and any impact on development costs identified.
An extensive library of reusable code and reference material helps to develop quickly and reliably. Development is done according to recognized naming conventions and with comments appended to all code.
Most solutions are implemented when about 50 - 80% completed. Feedback and testing from users enables fine tuning of the system, to finalise reports and to make sure it works properly.
This also creates hands-on training resulting in at least one user becoming a 'super-user' of the application. There is a transfer of skill and knowledge.
Most businesses are in an environment of constant change to remain competitive and to improve. Database applications model business processes and must be flexible enough to adjust as the business changes. Allow 2 - 15% of the original cost per annum for ongoing modifications, new reports and maintenance.
Doing business together
The initial consultation is free without obligation. A letter of engagement spells out type of service to be provided, and provides a terms of reference. Please get in contact if you would like more information, or fill in one of our application profile forms.