Entity Relationship Modeling - Will pay £10 to the person who can do this

ERM Excercise - Hardware Inventory

My Database assigment is as follows :

Design an Entity Relationship Model for the computing department within the college. The manager of the department wants a database which will hold the following information :

The manager needs to know what hardware is held in each classroom. He needs to keep a log of any errors within a specific peice of hardware. He wants to know when it was fixed, who has fixed it and who reported it, he also wants to know when the problem is closed off. It could be either a lecturer or a student who reports the problem. Each individual piece of hardware is individually bar coded.

He wants to keep details of each of the employees in the computing department, including the skills each employee has (hardware, software, network, trainer, web developer). He would also like to keep track of what the employee is doing on a day to day basis. Each employee is assigned to several projects and he needs to know what time has been spent on each project and also when they have been working on a project.


I'l pay £10 via Paypal to the first person who can create this for me as i am really struggelling with it. Thanks.