Entity-relationship diagram for an online fragrance store capturing customer orders, payment processing, and product catalog relationships. The schema models Customer entities placing PurchaseOrders, which are settled via PaymentRecords and contain OrderLines referencing specific Fragrances. Fragrances are organized by FragranceFamily and PerfumeHouse, with foreign keys enforcing referential integrity across all relationships. This normalized structure eliminates data redundancy while supporting complex queries on orders, payments, inventory, and product hierarchies. Fork this diagram on Diagrams.so to customize tables, add indexes, or adapt it for your e-commerce platform. The design demonstrates best practices for multi-entity transactional systems requiring audit trails and payment reconciliation.