Object-Role Modeling (ORM) is a very powerful method to model a relational database. It is very easy to use as well. However, the method is far from being well known and spread around. I decided to introduce ORM through couple of blogs. For a quick overview how an ORM diagram looks like, look at the picture bellow.
It represents a simple model to support an imaginary Sales application. I will explain how to come to such a model and how to create an ER model and DDL script from it with MS Visio in forthcoming blogs.
Dejan Sarka
Independent Consultant at Dejan Sarka S.P.
I am a trainer and consultant that focus on development of database & business intelligence applications.
Besides projects, I spend about half of the time on training and mentoring. I am the founder of the Slovenian SQL Server and .NET Users Group. and the main author or coauthor of eleven books about databases and SQL Server. I also developed many courses and seminars for SolidQ.
Besides projects, I spend about half of the time on training and mentoring. I am the founder of the Slovenian SQL Server and .NET Users Group. and the main author or coauthor of eleven books about databases and SQL Server. I also developed many courses and seminars for SolidQ.
Latest posts by Dejan Sarka (see all)
- Python for SQL Server Specialists Part 4: Python and SQL Server - April 24, 2018
- Python for SQL Server Specialists Part 3: Graphs and Machine Learning - April 11, 2018
- Python for SQL Server Specialists Part 2: Working with Data - March 22, 2018
