这是一个英语的题目,但是我看不懂,希望强人能帮我翻译一下!感谢了!我急用!!
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.
参考资料:嘿嘿,不错吧~