Draw only entity relationship diagrams for the following scenario. Include any attributes you think should be represented.
. Each engineer works on a number of projects. For every engineer a record is kept of his number, name title and salary.
. For every project a record is kept of its number, name, budget, and location. Additionally, the responsibility each engineer has on a particular project abd the amount of time spent on the project is noted.
. Clients contracts these projects. The client name, address and phone number must be recorded. The contract date i,e the date at which the clients signs the contract for a specific projects is also noted.
. A record is also kept of the machinery being used for a particular project. The name, amount and the date the machinery is needed for the project is recorded.