Perfume Hub ER diagram models a complete fragrance e-commerce database with Customer, PurchaseOrder, OrderLine, Fragrance, PerfumeHouse, FragranceFamily, and PaymentRecord entities. Customers place orders through the PlacesOrder relationship, orders contain line items via ContainsLine, and each line refers to a specific Fragrance through RefersToFragrance. Fragrances are manufactured by PerfumeHouses and belong to FragranceFamilies, while purchase orders are settled through PaymentRecords. This normalized schema supports order management, inventory tracking, payment processing, and product categorization for a multi-vendor perfume marketplace. Fork this diagram on Diagrams.so to customize entity attributes, add indexes, or extend relationships for your retail backend. The design separates concerns across order fulfillment, product taxonomy, and financial settlement for scalable e-commerce operations.