(Solved): 2. Draw an ER diagram for the following system clearly identifying any assumptions you have made in ...

2. Draw an ER diagram for the following system clearly identifying any assumptions you have made in your solution. The ER diagram must include all known attributes and entities as well as defining cardinality and optionality of the various relationships. Note that any many-to-many relationships must be resolved and define likely primary keys within the attributes. An electronics development company wishes to keep information on all the products it develops. Each project carries its own product number as well as a description and expected completion date. Each project will be subdivided into a group of development tasks with each task having a description and an associated budget. Although each task will carry an identifier, this will only be unique within the context of the project and not across the various projects. An engineer will be assigned either one or a group of tasks to carry out, although some of these tasks will have more than one engineer assigned to it. Tasks have to be defined for each project although these do not necessarily have to be defined at the start of the project. The system to be developed should record both the employee number and name