Explain the distinction between disjoint and overlapping constraints.


  • Disjoint Specialization Constraint - An entity in a higher level entity set cannot belong to multiple specialized entity sets.

  • Overlapping Specialization Constraint - An entity in a higher level entity set can belong to multiple specialized entity sets.