With SQL Server, this paper designs E-R model for Yeshu palm drinking sale including fact table for drink sale and dimension table for drink sale.

• 本文以SQL Server为工具,进行椰树饮料销售的E-R模型设计,包括饮料销售事实表和饮料销售维表。