You are a backend developer for a Global Consulting Firm global_consult.com, and are responsible for implementing a MySQL database system. Your task is to design and develop a web application allowing the firm's employees to perform the following functions: Create projects defining the client company, the recommended end date, the knowledge domain required for phase A of the project, and knowledge domain for phase B. (the consulting firm specializes in a limited number of domains including IT, Finance, Change Management) Additional attributes are needed to update projects' status, which progresses through the following steps - "not started", "phaseA_1", "phaseA_2", "phaseB_1", "phaseB_2", "completed". . . . Setup client profiles with standard information such as client-company name, company division, contact person, email, password. Note: Clients are Companies not individuals, although a contact person from a Client Company sets up and manages the client profile on behalf of that Company. (b) (c) (a) For the global_consult database, create an Entity Relationship Diagram (ERD), using crow's foot notation. Entities, relationships between entities, and appropriate association types should all be included in your diagram. Use the minimum number of table that provide for the required database functionality. [10] For each table of the database you designed in (a), list the primary and foreign keys. (d) Consultants are employees of the Global Consulting firms, who contribute to projects according to their competencies. One of the functionalities of the web application is creating consultant_allocations deal with the booking of consultants to projects, based on competency domains of consultants, and progress status of projects. At any point in time, a consultant can contribute to at most one project. A client can create several projects. A created project can then start at any time but must be completed by the recommended end date. Once a project has started, each one of steps "phaseA_1" through "phaseB_2" takes one month. Each consultant has one high-competency knowledge domain, and one medium- competency domain. Consultants are only booked on and contribute to projects during steps requiring their competencies, with a priority on high-skilled contributions. Create the tables you designed in your answer to part (a) with appropriate SQL code. [14] Give scenarios how a Project Leader can benefit from the database you have created, when he selects a project's start date and contributors throughout project's life. [2]