I recently started learning about data modeling.
After seeing @MDCCL's diagrams and thoughtful approach here, I'm interested in learning more about IDEF1X. I don't want to pay $200+ for the ISO standard.
So where can I begin to learn this appraoch?
Database Design – Start Learning IDEF1X Method of Model Notation
database-designerd
Related Question
- Mysql – Index optimization
- How to model an “is a” relationship in an ERD using Crow’s foot notation
- Database Design – Handling Redundant Foreign Keys in Surveys, Questions, and Responses
- Database Design – How to Use a Table When User Identifier Can Be One of Two Fields
- Postgresql – A (simple?) solution to the “logical decoding / sequence” problem in Postgres
- Database Design – Identifying Relationships Without FK in PK
- PostgreSQL – Entity Relationship Diagram for Chat/Conversation History
- Extended ER Model – Representing Foreign Key in Chen Notation
Best Answer
Answer left in comments by bbaird:
IDEF1X is commonly described as a methodology, and perhaps the reason we see it as "another way to represent a model" is that it was among the first and so all other graphical representations that have come since have borrowed from it in one way or another (typically through trying to copy features from ERWin). I've found this to be a good primer on the subject:
IDEF1X Introduction
You can also read the original standard here:
FIPS Standard • IDEF1X