DB diagram drawing

2. Database Design There is a small company which has only one database designer. This designer went missing! Now it is up to you to design the following database requirements. Department: There are many departments in the company and every department has a code and name. Personnel: Every personnel has a unique id and name, surname, phone number, address and date of recruitment and can only work in one specific department. Project: There are many ongoing projects in the company. Every project has a name, date of start, date of end, status. There can be many personnel in a project and every personnel can work more than one project. But every project has just one project manager Design a Entity Relationship Diagram which consists of: desired tables with unique values, relations between tables, primary and foreign key(s) of tables. Answer You can drag and drop the widgets to construct your diagram. If you'd like to include any explanatory comments on your work you can do so in the editor below the drawing widget. 100% + - Search Shapes