Putting the pieces together

Database Design

Quantech Database Modelling and Design Quantech Solutions can interpret supplied requirements produce a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a Data Definition Language, which can then be used to create a database. A fully attributed data model contains detailed attributes for each entity.

We can provide the logical design of the base data structures used to store the businesses data. In the relational model these are the tables and views.   This can also include the further process of forms and queries used in the dtabase application.

 

Insertion Anomaly - Quantech SolutionsQuantech can implement a smart logical design that can help prevent data ambiguation, and loss through modification anomalies.

For instance if data stored in a way that it is tightly coupled with other data, it is possible though updating or deleting a row in a table to inadvertantly loose important information. 

Deletion Anomaly - Quantech Solutions