桂林电子科技大学数据库总复习.pptVIP

An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;R S ;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System;An Introduction to Database System; 例：设某商业集团数据库中有4个实体集。一是“仓库〞实体集，属性有仓库号、仓库名和 等；二是“商店〞实体集，属性有商店号、商店名、地址等；三是“商品〞实体集，属性有商品号、商品名、单价；四是“售货员〞是实体集，属性有售货员编号，姓名，年龄等。 设每个仓库可存储假设干种商品，每种商品存储在假设干仓库中，每个仓库每存储一种商品有个日期及存储量；每个售货员只在一个商店工作，一个商店有多个售货员；一个仓库为多个商店供给多种商品，每种商品可以由不同的仓库供给给多个商店，每个商店可以由不同的仓库供给多种商品，该供给联系有月份和月供给量两个属性。 请根据上面的描述完成如下??目： 〔1〕根据给定的需求画出该系统的E-R图〔要求画出联系和实体的属性〕；〔2〕将〔