Check instructions on page 2 and given data is on page 5 and we have to use manager and employee as supervisor, but page 2 you have to work with instruction

You are designing and creating a database named COMPANY for an HR (Human Resource) Dept of a Software Consulting Company to manage their employees and their assigned work (projects) in the company. First Step to Design a Database Scheme (table structures) and Create a Database is Creating an E-R Diagram by Identifying Entities, Attributes and Relationships between any two Entities. In this lab, Create an E-R Diagram for the Company database from the raw data files given below and the business rules of the company given below using the symbols of E-R Diagram. To create the E-R Diagram for the Company database, we identified 4 Entities in class as below. Entities: - Employee - Department - Dependent - Weak Entity - Project For each Entity: 1. Identify all the attributes for each Entity 2. Identify the Attribute Type of each attribute per Entity - Multi-Valued Attribute, - Composite Attributes, - Key attribute: - If there are more than one key attribute, mark all as a possible key attribute. - If there is no key attribute in an Entity, identify multiple attributes as a composite key attribute. - Derived Attributes. 3. With the given raw data at the end of this lab sheet and the given Compamy rules as specified below, Identify a relationship between any two Entities to create an E-R Diagram for the Company database scheme. Note that there could be more than one relationship between two entities. For example, between Employee and Department, there are more than one relationship. There could be no relationship between some pairs of two entities. Note that it is decided here that we don't create a separate entity for Supervisor role and Manager role separately as an Entity. The Supervisor role and the Manager role are combined as one integrated Employee Entity. Company Rules: - Every employee should work for only one department. - A Dept could have no employee. - Every employee should work on at least one project or more. - Every project should have at least one employee or more that work(s) on - A Project can be worked by multiple employees - A Manager is the one who manages a Department. - Only some of the employees are Managers. - A Supervisor is the one who supervises his/her regular employees. - Only some of the employees are Supervisors. - Every Department can have only one manager. - A department controlls projects. - Every Project should be controlled by only one department. - Every dependent should have only one employee that he/she belongs to. For each realtionship, identify the followings: - Name the realtionship - Identify the Cardinality of each relationship between two entities as either 11 1N or N1 NM - Identify participant types: Total or Partial Participation for each entity that participates in a relationship - If there is no clear indication either from raw data or the rules for participation info of a relationship, leave it as partial participation as default Submission: Submit your Lab2_ 1 report in doc file with your E-R diagram (either in print or pencel and paper would be ok). Give a brief explaination of the identified relationships and cardinality of each realtionship in your E-R diagram. Submit Both on Blackboard and a printout in Class. Example of a Relationship with Cardinality between Employee and Departmemnt in E-R diagram Figure 3. Symbols of ER diagrams 72 Chapter 3 Data Modeling Using the Entity-Relationship Model Company EMPLOYEE \begin{tabular}{|l|l|l|l|l|l|l|} \hline NAME & SSN & BDATE & ADDRESS & SEX & SALARY & SUPERSSN \\ \hline John B Smith & 123456789 & 09-Jan-55 & 731 Fondren, Houston, TX & M & 30000 & 987654321 \\ \hline Franklin T Wong & 333445555 & 08 Dec-45 & 638 Voss, Houston, TX & M & 40000 & 888665555 \\ \hline Joyce A English & 453453453 & 31Jul62 & 5631 Rice, Houston, TX & F & 25000 & 333445555 \\ \hline Ramesh K Narayan & 666884444 & 15Sep52 & 975 Fire Oak, Humble, TX & M & 38000 & 333445555 \\ \hline James E Borg & 888665555 & 10-Nov-27 & 450 Stone, Houston, TX & M & 55000 & \\ \hline Jennifer S Wallace & 987654321 & 20-Jun-31 & 291 Berry, Bellaire, TX & F & 43000 & 888665555 \\ \hline Ahmad V Jabbar & 987987987 & 29-Mar-59 & 980 Dallas, Houston, TX & M & 25000 & 987654321 \\ \hline Alicia J Zelaya & 999887777 & 19-Jul-58 & 3321 Castle, SPring, TX & F & 25000 & 987654321 \\ \hline \end{tabular} DEPARTMENT \begin{tabular}{|l|l|l|l|l|} \hline DNAME & DNUMBER & MGRSSN & MGRSTARTDATE & DLOCATION \\ \hline Headquarters & 1 & 888665555 & 19-Jun-71 & Houston \\ \hline Administration & 4 & 987654321 & 01-Jan-85 & Stafford \\ \hline Research & 5 & 333445555 & 22-May-78 & Bellaire,Sugarland,Houston \\ \hline Automation & 7 & 123456789 & 06-Oct-05 & Cleveland \\ \hline \end{tabular} PROJECT