XYZ Corporation, an IT and Digital media company is restructuring their organisation, part of which includes redesigning their database into a relational database. You have been tasked with redesigning the new database. You have been given the following business rules, a manager can be a project manager or project lead. A project manager oversees a department, a project lead oversees a project. An employee can be a programmer or designer. A programmer must be front$-$end or back$-$end or both. A designer must always have a project they are working on$.$ Draw the Extended Entity Relationship Diagram for XYZ corporation and include all the necessary attributes. $(30$ Marks$)$