DO PART 2 PLEASE

Part 1: Entity Relationship Diagram Please create an Entity Relationship Diagram ERD) for the below scenario. Be sure to identify the entity name, the primary key, attributes that make sense and the cardinality. You have been hired to develop an ERD for Al Consulting Company. Al maintains information on anyone that might do business with them now or in the future. They collect this information from a Web Form information includes Company Name and Company Representative Na A company may have several projects underway with Al such as doing an ERP System Upgrade, migrating data servers to an Infrastructure-As-A-Service environment, developing a Salesforce.Com integration (API) to its Human Resources System, etc. Projects have different costs as well as start and end dates. Al wants to track perspective (potential) and current customers, employee and project assignments. The company has several departments. Each department has a supervisor and at least one employee. Employees must be assigned to at least one, but possibly more departments. At least one employee is assigned to a project, but an employee may not be assigned to any projects. Part 2: Database Design Please convert your ERD done for the above scenario into a database design. What are the necessary primary keys, foreign keys and fields? What are the relationships