To manage the materials of a factory, please give the E-R diagrams. Such entity sets are involved as below: Warehouse: with attributes as Number, area and telephone Accessory : with attributes as...

Extracted text: To manage the materials of a factory, please give the E-R diagrams. Such entity sets are involved as below: Warehouse: with attributes as Number, area and telephone Accessory : with attributes as number, Name, Specification, price and description Supplier: with attributes as Number, name, address, telephone and асcount Project : with attributes as number and budget Employee : with attributes as number, name and age


Extracted text: The relationships among these entity sets are listed as below: A kind of accessory can be deposited in more than one warehouse. A warehouse can accommodate more than one kind of accessory. There can be more than one employee in a warehouse, and a employee can work in only one warehouse. Some employee can leader others. A supplier can supply various accessories to various projects. A project can use accessories supplied by various suppliers. A kind of accessory can be supplied by various supplier. *