Answer Happy

4. Database Designer Missing! 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. Use whiteboard and its utilities to draw shapes, arrows, text etc. Example ER Diagram: Table1 Table2 PK PK ID ID row1 FK TablelID row2 row3