The purpose of this assignment is to allow you to practice designing and developing an ER diagram by using an appropriate tool.
This assignment requires you to develop an ER Diagram for a database that is used to maintain basic information concerning the hours spent on projects by employees in a small advertising company. A customer may have many projects and an employee may have worked on many projects. Each project is for just one customer.
The tables needs to include the following:
• Customer(id, name).
• Employee(id, name, department id, salary).
• Project(id, title, customer id).
• EmpProj(employee id, project id, hours).
Primary keys and foreign keys need to be identified as well. Draw the ER Diagram using any tool that you want. The easiest is probably a word processor, but you could also use a drawing tool such as Visio.