Development services for MSSQL, MySQL, Oracle, and DB2 databases. We can work directly with your in-house staff or, if the situation dictates, develop the entire project from design through training and implementation.
Do you have existing data in MSSQL, MySQL, Oracle, Access, DB2, or other database that doesn't allow for information sharing? We can help you design, develop, and install custom database software tools that will provide access to all of your business data.
Data modeling is the process of creating and extending data models which are visual representations of data and its organization. The ERD (Entity Relationship Diagram) is the most popular type of data model. Data models exist at multiple levels including:
The Conceptual Data Model describes data from a high level. It defines the problem rather than the solution from the business point of view. It includes entities and their relationships. Typically the conceptual data model is developed first.
The Logical Data Model describes a logical solution to a data project. It provides more details than the conceptual data model and is nearly ready for the creation of a database. These details include attributes, the individual pieces of information that will be included. Typically the logical data model is developed second.
The Physical Data Model describes the implementation of data in a physical database. It is the blueprint for the database. Typically the physical data model is developed third.
With experience in data modeling since 1988, JT Watson Consulting provides both entity-relationship and dimensional modeling expertise.
Jim Watson JT Watson Consulting jtwatsonconsulting com