This an example question offered to draw ER diagram; I'm not clear how to draw these 2 questions if anyone can please help.
- Consider the following statement.
“Manufacturer orders parts from suppliers. A given manufacturer can order a particular part from many suppliers.”
a) Identify the entities.
b) Draw a suitable ER Diagram.
- "Multicolor (Pvt) Ltd., a manufacturing company, is located at 35/1, Galle Road, Colombo4. It has 6 departments: Production, Business Development, Human Resource Management, Finance, IT and Research & Development.
Rosell, 23 years old, a diploma holder who is residing at 54/A, Kirula Road, Narahempita joined the company as a management trainee. She joined the Production department on 01/01/2005. When Rosell successfully completed her Commerce degree, she was promoted as Finance Executive and transferred to the Finance department from 02/02/2006. Considering her MBA qualification, the management of the company promoted her as Assistant Manager - Business Development and transferred to the Business Development department with effect from 03/03/2008.
a) Identify the entities and their attributes.
b) Draw an ER diagram to model the above scenario. "
If anyone can give a idea how to create this ER diagram
