In a relational data model, for normalization purposes, product category lookup, product sub-category lookup, product lookup, and and product feature…
Dimension Table: Dimension table is one that describe the business entities of an enterprise, represented as hierarchical, categorical information such as…
How to create Identifying Relationship with Cardinality of many to many relationship: Identifying relationship: If a foreign key column/multiple foreign…
What is Non-Identifying relationship? If a column (foreign key) / multiple columns (foreign key columns) referencing some table becomes a…
Xcase - Overview: Xcase is a powerful and intuitive data modeling tool. It automates database creation and maintenance, making the…
How to create Data Modeling Objects in Toad? Here in this section, we will create a physical data model instead…
How to create a Physical Data Model using Erwin 4.1.4 version? 1: Change the view from "Logical to Physical" from…
How to create a Logical Data Model using Erwin 4.1.4 version? In the following section, a simple example with a…
All Fusion Erwin Data Modeler: All Fusion Erwin Data Modeler commonly known as Erwin, is a powerful and leading data…
Why do we need to create Domains, Defaults & Check Constraints? When you create domains, defaults and attach them to the…