We design relational database models for Web and Mobile applications with 3rd NF and BCNF. We also design data warehouse layered structure in 3rd NF, Star or Snowflake schema using Kimball Model ( Dimensional Model ) with Change Data Capture (CDC) and Slowly Change Dimension ( SCD ) types implementation using popular Data Modeller tools. In data warehousing architectural perspective, we may apply Enterprise Data Warehouse ( EDW ) or Data Vault approach in database design depending on the requirements and data sources.

We are experts on:

• Erwin
• SAP PowerDesigner
• DBeaver