The ERD consists of four main tables: City, Customers, Products, and Sales. Cities store location, population, and rent data. Customers belong to cities, while products store coffee item details. Sales links products and customers, capturing transaction totals, ratings, and dates for analysis.
sql postgresql data-analysis database-schema sales-analytics business-insights coffee-sales erd-modeling
-
Updated
Jun 22, 2025