please draw a entity relationship diagram for the information provided below. then draw a relational schema for the ERD
1. For each consultant: a unique identifier, consultant name (composed of first name, middle initial, last name), start date with the company, the number of years with the company, skills that the consultant has (one or multiple skills). 2. For each project manager: a umique identifier, project manager name (composed of first name, middle initial, last name), start date with the company, the number of years with the company, PMP Certified (Yes/No) 3. For each customer: a unique identification, well as the customer's name composed of the customer's first, middle initial, and last name, and a phone number. 4. For each supervisor: a unique identifier, name (composed of first name, middle initial, last name), start date with the company, the number of years with the company, number of supervised contracts, and (if supervisor owns AC Inc. stock) number of stocks owned. (Not every supervisor owns AC Inc. stock.) 5. For each contract: a contract id, contract start date, estimated contract length (in days), estimated contract end date, actual contract end date, and actual contract length (in days). Two or more contracts can have the same contract id, but all contracts for the same customer will have different contract ids. 6. Each contract is managed by exactly one project manager. A project manager manages one contract or no contracts at all. 7. Each contract has at least five consultants assigned to it. A consultant is assigned to one contract. 8. A customer has at least one contract but may have many. Each contract is associated with one customer. 9. Each contract is supervised by exactly one supervisor. Each supervisor must supervise at least one contract but can supervise many contracts. 10. Each supervisor has one or more consultants assigned as administrative helpers. A consultant can be assigned as an administrative helper to between zero and many supervisors. We keep track of how many hours per week a particular consultant is working as an administrative helper for a particular supervisor