Services
Databases
We have many years’ experience designing relational databases and implementing them on popular RDMs such as Oracle, MySQL, MS SQL Server and MS Access.
Almost all of the websites we build use a database. We also design and develop databases and database applications for internal use, for example to track customers, contacts, addresses, and to run reports.
Database Design
We always follow our Data Modelling methodology when we design and implement a database. One of the outputs of the methodology is an ERD (Entity Relationship Diagram), which illustrates the tables of the database and the relations between them. This is included in the Specification & Design deliverable of a project.
A well-designed, normalised database ensures the integrity of your data and enables you to run accurate reports.
Front Ends and Reporting
Most databases require a front end to maintain and view the data and to run reports. For fast development time, where an application will be used by a limited set of users, we often develop applications using MS Access. This enables clients to administrate their data and run reports using easy-to-use Windows-style forms. Access also has good reporting capabilities so that we can quickly develop tabular reports, graphs and charts.
We also develop solutions aimed at a higher volume of users, delivered using web technologies so that they are accessible from a browser. We have experience building tabular HTML reports, and integrating with third-party software to generate graphs and charts.