谁能帮助我翻译一下这篇英语文章啊!急用!!

这是一个英语的题目,但是我看不懂,希望强人能帮我翻译一下!感谢了!我急用!!
Tutorial 5 database design with Entity-Relationship (E-R) Diagram

Draw Entity-Relationship diagrams for each of the following. For each entity identify the key field and attributes. Ensure that a foreign key is used to establish the relationship between the entities.

(a) An item is identify by an item number, and has a description and quantity available. Warehouses are identified by a warehouse number and have a name and address. Items are stored in warehouses. Each warehouse may store many items, but a given item can be only be stored in the one warehouse.
(b) A department is identified by a department number and has a title and budget. Projects are identified and a project number and have a start data. Each project can only be managed by one department, although departments may manage more than one project.
(c) A fault occurs on one item of equipment, although a given item of equipment may have many faults. Each fault is recorded using a fault number, data and description. Each item of equipment is identified by an equipment number, description and type and is located in a building. Buildings have a name and may house many pieces may pieces of equipment.
(d) A course consists of many subjects, but each subject can only be associated with one course. Each subject is coordinated by a lecturer and each lecturer can only co-ordinate one subject. Subjects and courses are identified by subject and course codes, and have a name. Lecturers are identified by an ID and have a name, room number and telephone contact number.
(e) Persons in a department are identified by a person id and have a surname, given name and office number. Each person is responsible for filling customer orders (having an order-number, data, item description and quantity ordered). Each person may be responsible for more than one order, but each order is the responsibility of only one person. Ordered items are manufactured in a series of jobs. Each job identified by a job number and has an associated cost.

What would be effect on the E-R model if an order could be the responsibility of more than one person?
(f) An order contains an order number and data. Orders may be made for many items. An ordered item is identified by an item number and contains the quantity ordered. An order is placed with a supplier. Suppliers are identified by a supplier code and have a name and address. Each order can only be placed with one supplier, although each given supplier can receive many orders.

5数据库设计与实体补习关系(ER)图
利用实体关系图对下列. 对每一个实体和属性确定重点. 确保重点用于建立外交关系的实体.
(一)一个项目一个项目的确定,也可说明和数量. 仓库内发现了一间仓库,有许多的名称和地址. 存放物品的仓库. 每个仓库可以存放许多物品,但是只能有一个项目存放在一个仓库.
(B)已确定一个部门一个部门的名称及数量,并有预算. 一些项目已确定,并已开始项目的数据. 每个项目只能由一个部门管理,但管理部门不得超过一个项目.
(C)发生故障的设备项目之一,但由于有许多项目的设备故障. 每错就是错用数字记录、数据和说明. 每个项目的设备,确定设备数量、类型、说明和位于大楼. 建筑物名称,可能有许多家可件件设备.
(D)中有许多问题,但每个主题只能有一个过程联系. 每一个主题是由讲师和讲师各只能配合主题之一. 学科和课程中所确定的主题和密码,并有名称. 讲师身分,有一个确定的名称、数量、联络电话号码房间.
(五)确定一个部门人员的身分,有一个人姓、名字和办公室号码. 每人负责填写订单客户(有秩序的一些数据,说明项目和定购量). 每人负责一个以上的命令,每一个命令,但只有一人负责. 订购物品制造了一系列的工作. 每个职位的工作,并提出了相关的费用. 什么是影响电子住宅模式,如果能有一个以上的人负责?
(六)载有秩序的命令和数据. 可令许多物品. 一个命令一个确定的项目,包括项目的定购量. 与供应商订购了. 确定了供应商名称、地址代码及有. 每一个地方,只能供应,但由于各供应商能获得不少订单.

参考资料:嘿嘿,不错吧~

温馨提示:内容为网友见解,仅供参考
第1个回答  2006-05-18
这个是设计数据库的文章,涉及到E—R图,建议你直接找些中文看吧,翻出来时间太长了
相似回答
大家正在搜