Understanding Entity-Relationship Diagrams and Modifying Existing Ones to Create Ternary Relationships for Awarding Prizes to Buyers

How to Enforce Maximum Constraint on One-to-Many Relationship in Oracle SQL Using Compound Triggers