er关系模型.docVIP

作业四. Comprehensive Application（综合应用题） 1．To manage the materials, please give the E-R diagrams, and turn the E_R diagrams into relational data models. The primary key and foreign keys should be labeled out.（画出E-R图，并将E-R图转换为关系模式，主键和外键必须标出） 1.1 Suppose to establish an enterprise database, the enterprise has more than one unit, of each unit there are several employees, an employee belongs to only one unit, and an employee works only in a project, but a project has many employees to work. There are multiple suppliers for each project to supply different devices. Units’ attributes are: Unit name, phone. Attributes of employees are: employee number, name, sex. The devices’s attributes are: device number, device name, origin. Suppliers attributes are: name, phone. Projects’ properties are: project name, location. 假设要建立一个企业数据库,该企业有多个下属单位每一单位有多个职工,一个职工仅隶属于一个单位,且一个职工仅在一个工程中工作,但一个工程中有很多职工参加工作,有多个供应商为各个工程供应不同设备。单位的属性有：单位名、电话。职工的属性有：职工号、姓名、性别。设备的属性有：设备号、设备名、产地。供应商的属性有：姓名、电话。工程的属性有：工程名、地点。 Unit（Uname,Uphone）Employee(Eno,Ename,Esex,Uname,Pname) Project(Pname, PAr) Device(Dno, Dname,DAr) Supplier(Sname,Sphone) supply(Sname,Pname,Dno,Qty) 1.2 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, addr, telephone and account Project : with attributes as number and budget Employee : with attributes as number, name and age 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. A employee can lead 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. War