Database Structure

Database Structure

No matter what your requirements are, we can design a database solution that will satisfy your goal. Database design and data structures play a very vital role in success of complex applications.

We have extensive experience in designing from this perspective. Getting the design right the first time means your application functions perfectly every time.

Multi User Interface

Whatever the size of your database application, we will always supply the end solution in two seperate parts.
  • Back End Database

  • Front End Application


Back End Database

Back End Database

The Back End Database is stored in a central location - either on a server (recommended) or a shared folder on a desktop.

Relational Tables
This database houses all the data entered by you users in a number of relational tables. This means that each piece of data is only stored once within your database. For example, your product details are only stored in one table. Any other table that links to a product contains only a number representing the unique ID of the product it refers to. This greatly reduces the storage space required for your database.

Simultaneous Connections
Placing the data in one central location allows simultaneous use for multiple users across any number of PCs. This ensures that all your users are using the most up to date data possible, reducing the potential for errors.

Backup
Possibly the most importat part of any business is a good backup routine! Because your data is stored in one central location, the backup overhead is also greatly reduced as their is only ever one location that requires backing up.

Front End Application

Front End Application

The Front End Application can be installed on any number of PCs allowing simultaneous use for multiple users.

Navigation in our applications is done via a Fully Customised Ribbon. The Ribbon is part of the new the Office Fluent user interface (UI). Throughout the Office suite, Microsoft replaced the traditional menus and toolbars with this new Ribbon so that you can find and use the features you need - and use - a lot easier. It was designed to be intuitive for you and, perhaps most importantly, easy to get accustomed to.

Because the back end database is separated from the front end application, if you need to re-install or renew your PC, you can do so without having to worry about losing your data.

Upgrades are also greatly simplified as these are simply a case of un-installing the old application and installing the new.

SellerDeckMicrosoftredhat Enterprise LinuxMicrosoft Certified ProfessionalDigiCert Affiliate PartnerSophos Silver Partner