Concentrating on small businesses the following services are available

Database selection

Every business needs to store information but not every database will fit the business needs or budget. Selecting the right database product is essential whether it be for a web site or client/server applications. The number of concurrent users and the ratio of read to read/write users should also be considered at an early stage.

Database design

Once the database product has been chosen the task of designing the database can begin. Most databases today will be relational and have SQL capabilities. This will require the design to go through several normalization steps to get the best data model.

Database connectivity

After design and data loading the final step is the data access. MGSoft have experience in using many methods including JDBC, ODBC, native connections via VBasic and embedded SQL. The connection of a web browser to a database can be simple or complex depending on the tools chosen to meet the business requirements.