Custom Database Design and Development

A database solution created to your specific requirements, to do whatever you require. We handle the whole project from initial concept to implementation and training, and place special emphasis on making the database as user-friendly as possible so it's a joy to use rather than a chore! Our speciality is in creating database systems running on Microsoft Windows workstations.
Our skills are:

• Microsoft Access
• Microsoft SQL Server
• Firebird

What's a Database Solution? 

A database solution is a program (or set of programs) that is database-centric, and helps you store, manage and process information. So what does it take to create professional database solutions? Let's take a look at the major areas we focus on to create the typical database management system. For more information about databases then see What is a Database

Define Entities

As you might imagine your typical database management system is going to have at least one database. Each database will have one or more entities, called tables. Once we understand your requirements and have created the proper user interface, we are going to need to create these entities. Each entity/table will have one or more fields, each of which will have properties. For example, we'll define if the field is required, if it has to be unique, and if we need to index or sort on it. All of this information usually goes into a Database Dictionary.

Define Entity Relationships

As database developers, once we've created our tables we need to graphically draw the relationships between them. This helps everyone understand how information in one table relates to information in another. An ER Diagram tells us a lot about our database system. For the database developer or administrator, this information is crucial.

Define Business Rules

Database management systems operate under a set of clearly defined business rules. These rules are a logical representation of your organization's own business rules. For example, a business rule may define that an Order cannot exist unless it is linked to a customer. Or it may define that each customer must have one and only one customer type. Another example is that a customer balance cannot be negative. Business rules are used to maintain the integrity of the database, making sure that only good data is stored within it. The phrase "garbage in, garbage out" must have been coined by a database developer.

Build User Interface (UI)

The next step is to map the databases, fields, business rules and other entities of the database to the user interface (UI). Although you may think that each module within the system will relate to one or more tables, in reality the user interface and database structure are totally independent. We design our user interfaces to match your business process. The application's user interface is designed to provide maximum efficiency. The database is designed for speed, integrity and security.

Create Output (Reports)

When building a database solution, usually (but not always) the last step is to create the reporting, or output portion of the system. Actually, when designing a database system we like to review the current or desired reports/output first.

There's a lot more to building a professional database management system, but this should give you a good idea of the tasks involved.