Data Modeling by Example
1. Introduction 2
2. Certification 2
3. Getting Started 3
4. ‘Bang for the Buck’ Data Models 23
5. Design Patterns 23
6. Master Data Management (MDM) 36
7. Build your Own 57
8. Generic Data Models 79
9. From the Cradle to the Grave 88
10. Commercial Web Sites 108
11. Vertical Applications 109
Appendix A. Business Rules 114
Appendix B. Glossary of Terms 114
1. Introduction
1.1 Our Approach
This book adopts a unique approach which is based on using existing Data Models as the basis for designing new ones to meet specific requirements.
We have almost 800 Data Models on our Database Answers Website and they define our starting point –
• http://www.databaseanswers.org/data_models/index.htm
We have used the Dezign Data Modelling Tool to create most of the Data Models in this book.
I chose it because it is powerful, flexible and affordable.
Members of the Database Answers Community and people who buy this book can purchase Dezign and benefit from a discount of 25%.
In order to gain the benefit of this discount, all you have to do is to send an email to dba_requests@barryw.org with your Database Answers Community ID.
We will then send you the order instructions.
1.2 Tutorials
We have a number of useful Tutorials on our Website.
Here are two of them :-
• Data Modelling with two young people visiting Windsor Castle
o http://www.databaseanswers.org/tutorial4_data_modelling_dimple_and_toby_visit_windsor_castle/index.htm
• Beginner’s Guide to Data Modelling using Dezign –
o http://www.databaseanswers.org/tutorial4_data_modelling/index.htm
2. Certification
Certification in Data Modelling is available from Database Answers
Details will be available on our Website :-
• http://www.databaseanswers.org/certification.htm
3. Getting Started
This material is also available as a Tutorial for Amazon and
2. Certification 2
3. Getting Started 3
4. ‘Bang for the Buck’ Data Models 23
5. Design Patterns 23
6. Master Data Management (MDM) 36
7. Build your Own 57
8. Generic Data Models 79
9. From the Cradle to the Grave 88
10. Commercial Web Sites 108
11. Vertical Applications 109
Appendix A. Business Rules 114
Appendix B. Glossary of Terms 114
1. Introduction
1.1 Our Approach
This book adopts a unique approach which is based on using existing Data Models as the basis for designing new ones to meet specific requirements.
We have almost 800 Data Models on our Database Answers Website and they define our starting point –
• http://www.databaseanswers.org/data_models/index.htm
We have used the Dezign Data Modelling Tool to create most of the Data Models in this book.
I chose it because it is powerful, flexible and affordable.
Members of the Database Answers Community and people who buy this book can purchase Dezign and benefit from a discount of 25%.
In order to gain the benefit of this discount, all you have to do is to send an email to dba_requests@barryw.org with your Database Answers Community ID.
We will then send you the order instructions.
1.2 Tutorials
We have a number of useful Tutorials on our Website.
Here are two of them :-
• Data Modelling with two young people visiting Windsor Castle
o http://www.databaseanswers.org/tutorial4_data_modelling_dimple_and_toby_visit_windsor_castle/index.htm
• Beginner’s Guide to Data Modelling using Dezign –
o http://www.databaseanswers.org/tutorial4_data_modelling/index.htm
2. Certification
Certification in Data Modelling is available from Database Answers
Details will be available on our Website :-
• http://www.databaseanswers.org/certification.htm
3. Getting Started
This material is also available as a Tutorial for Amazon and