Need help with 1-7

Can you please draw the E-R diagram with MS Visio

Database Scenario The COMPANY database keeps track of a company's employees, departments, and projects 1. The company is organized into departments. Each department has a unique name, a unique number, and a particular employee who manages the department. We keep track of the start date when the employee began managing the department. A department may have several locations, 2. A department controls a number of projects. Each project has a unique name, a unique number 3. We store each employee's name, social security number, address, salary, sex and birthday. An employee is assigned to one department but may work on several projects, which are not necessarily controlled by the same department. We keep track of the number of hours per week that an employee works on each project. We also keep track of the direct supervisor of each employee. An employee must be either full-time or part-time. 4. We want to keep track of the dependents of each employee for insurance purpose. We keep each dependent's name, sex, birthday and relationship to the employees. Manages Controls Workd on Works For 1:N 1: N I:N M:N Business Rules One employee must work for one and only one department. One department must have 4 or more employees. One employee may manage one and only one department. One department must be managed by one and only employee. One department may control one or more projects. One project must be controlled by one and only one department. One employee must work on one or many projects. One project must have one or many employees to work on. One employee may have one or more dependents One dependent must belong to one and only one employee. One employee may supervise many other employees One employee may be supervised by another employee Part time employee must be an employec. Full time employee must be an employee. I. Given the above database scenario and business rules, do the following things: 1. Identify entity types and relationship types using relationship matrix 2. Draw an ER diagram with 1) entity types, 2) relationship types, 3) keys, 4) cardinalities and 5) attributes 3. Map ERD/EERD diagrams in HWK2 to a relational database indicating the relation name, attribute name and primary key for each relation. Add appropriate additi scenari0. onal field according to Table name: Table name Table name: Table name: Table name: Table name: Table name: Table name: 4. Establish join paths for the above relational database using the referential integrity by 3. Map ERD/EERD diagrams in HWK2 to a relational database indicating the relation name, attribute name and primary key for each relation. Add appropriate additional field according to scenario Table name: Table name: Table name: Table name: Table name: Table name: Table name: Table name: 4. Establish join paths for the above relational database using the referential integrity by drawing arrow lines between the above tables. Indicate all the foreign keys (FK) 5. Do functional dependency analysis 6. Show the relational schema after normalization 7. Indicate what normalization form each table is in