Structured entity relationship model

The SERM (structured entity relationship model) is an amplification of the ERM which is commonly used for data modeling. It was first proposed from Prof. Dr. Elmar J. Sinz in 1988. The SERM is commonly used in the SAP-world for the data modeling.[1]

Aims
  1. structuring of large schemes
  2. visualization of existence dependency
  3. avoidance of inconsistencies
  4. avoidance of unnecessary relationshiptypes

SERM symbols

SERM example

  • Customer and article are independent entities
  • Every order is referred to one customer. Orders without customers are illegal (order is an ER type). Customers 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 customers are illegal. Customers 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
gollark: I have a Ryzen 3 1200 and Nvidia's EXTREMELY POWERFUL GTX 1050.
gollark: 60FPS 1080p forever!
gollark: What? Intel Xe cards are said to be arriving in 2020.
gollark: I'm waiting for 2020 or so to upgrade. Mostly waiting for Intel dedicated GPUs to hopefully shake up the market.
gollark: It's like saying "Intel is better than AMD because Intel's Xeon Platinum 8280 beats AMD's best desktop CPU".

References
  1. Michael Röthlin (2010). Management of Data Quality in Enterprise Resource Planning Systems. BoD – Books on Demand. pp. 118–. ISBN 978-3-89936-963-2.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.