Data Modeling

Is the process of creating a data model for an information system by applying formal data modeling techniques. There are many different types of data modeling techniques, methodologies, and software tools depending on the data requirements and usage of the model.

---

Relational Data Modeling

---

Relational Data Modeling

Relational Data Modeling is the art of designing data structures for entities and their relationships to provide a well defined reusable definition of the data. Relational Data Modeling is based on set theory mathematics. An good overview of Relational Data Modeling can be found on Wikipedia.

The leading Relational Data Modeling Software is ER/Studio Data Architect by Embarcadero, CA ERwin Data Modeler CA Technologies, and PowerDesigner by SYBASE. Each of these tools provide graphical interfaces to create and edit relational data models. However, to really make these tools productive requires learning to "automate" them using their macro (i.e., scripting) language.

The following are some topics on different aspects of Relational Data Modeling.

• ER/Studio Data Architect Macro Language