A Real-Life ER Model

I am glad having finished archiving the database of my customer, one of the biggest online whole sellers in Taiwan, and deleted 2,397,870 aged products successfully!

I designed this entity-relationship model (ER model) for my customer 5 years ago. A single product (entity) is stored in 16 database tables with data integrity enforcement:

  • Entity integrity: Primary Key constraint
  • Semantic integrity: Data Types and length
  • Referential integrity: Foreign Key constraint/relationship

PS. It’s a master/details structure. The name of the Details tables is removed.

Leave a Reply