Structured entity relationship model: Difference between revisions

Revision as of 14:17, 30 July 2015

Latest revision as of 09:01, 5 May 2020

(8 intermediate revisions by 7 users not shown)

Line 1:

{{Cleanup|reason=Spelling errors in images as well as use of images whose content could be better represented with smaller images, tables and text.|date=July 2019}}

The '''SERM''' (Structured Entity Relationship Model) is an amplification of the [[Entity-relationship model|ERM]] which is commonly used for [[data modeling]]. It was first proposed from Prof. Dr. [[Elmar Sinz|Elmar J. Sinz]] in 1988. The SERM is commonly used in the [[SAP AG|SAP]]-world for the [[data modeling]].<ref name="Röthlin2010">{{cite book|author=Michael Röthlin|title=Management of Data Quality in Enterprise Resource Planning Systems|url=http://books.google.com/books?id=wyheQllcyh0C&pg=PA118|year=2010|publisher=BoD – Books on Demand|isbn=978-3-89936-963-2|pages=118–}}</ref>

{{Use dmy dates|date=December 2017}}

The '''SERM''' (Structured'''structured Entityentity Relationshiprelationship Modelmodel''') is an amplification of the [[Entity-relationship model|ERM]] which is commonly used for [[data modeling]]. It was first proposed from Prof. Dr. [[Elmar Sinz|Elmar J. Sinz]] in 1988. The SERM is commonly used in the [[SAP AG|SAP]]-world for the [[data modeling]].<ref name="Röthlin2010">{{cite book|author=Michael Röthlin|title=Management of Data Quality in Enterprise Resource Planning Systems|url=httphttps://books.google.com/books?id=wyheQllcyh0C&pg=PA118|year=2010|publisher=BoD – Books on Demand|isbn=978-3-89936-963-2|pages=118–}}</ref>

==Aims==

Line 7 ⟶ 9:

# avoidance of unnecessary relationshiptypes

==SERM-Symbols symbols==

[[Image:SERM-Symbols.JPG|600px]]

==SERM-Example example==

[[Image:SERM-example.JPG]]

* [[Customer]] and article are independent entities

* Every order is referred to one customer. Orders without [[customer]]scustomers are illegal (order is an ER Typetype). [[Customer]]sCustomers without any orders are legal because they are independent Entities.

* To every order there is belonging at least one order item.

* Every order item is related to exactly one order.

* Every invoice is referred to one [[customer]], as well. Invoices without [[customer]]scustomers are illegal. [[Customer]]sCustomers without any invoice are legal.

* To every invoice there is belonging at least one invoice line item.

* Every invoice line item is related to exactly order item. An order item could be calculated or not.

* SERM is already in the [[third normal form]]

Line 28 ⟶ 29:

[[Category:Data modeling]]

[[Category:Diagrams]]

[[Category:Modeling languages]]