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 relationships between the entities.

1. An item is identified 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.
    
2. A department is identified by a department number and has a title and budget.
   Projects are identified by a project number and have a start date. Each project can only be managed by one department, although departments may manage more than one project.
    
3. 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, date 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 location, and may house many pieces of equipment .
    
4. A course consists of many subjects, but each subject can only be associated with one course. Each subject is co-ordinated 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.
    
5. Persons in a department are identified by a person id and have a surname, givenname and office number. Each person is responsible for filling customer orders (having an order-number, date, 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 is 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?
    
6. An order contains an order number and date. 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.