ERD This is a simple list table of a company trying to keep track of employee assignment to company projects (in otherwords, not a database but a flat one table file). You will design a database for this company so that they won't berelying on a simple 1 table list system to keep track of their data. Looking at the table below, identify the separateentities and attributes and design a logical level Entity Relationship Diagram for this company.Project Project NameCodePC010PC010PC010PC011PC011PC011PC012PC012PC012ReservationSystemReservationSystemReservationSystemHR SystemHR SystemHR SystemAttendanceSystemAttendanceSystemAttendanceSystemProject ProjectManager BudgetMr. AjayMr. Ajay 120500Mr. Ajay 120500Mrs.CharuMrs.CharuMrs.CharuMr.RajeshMr.RajeshMr.Rajesh120500 $100Employee EmployeeNo.Name500500S101500500 S103S102710700S104500500 S315710700 S137S218710700 S109MohanVipulRiyazPavanPoojaRahulAvneeshDepartmentNo.VikasD03Jitendra D02D02D01D03D01D03D02D01Department HourlyNameRateDatabase21.00TestingITDatabaseTestingITDatabaseTestingIT16.5022.0018.5017.0023.5021.5015.5020.50

This is an physical Entity Relationship Diagram. It has been partitioned into three tables…

This is a simple list table of a company trying to keep track of employee assignment to company projects (in other words, not a database but a flat one table file). You will design a database for this company so that they won't be relying on a simple 1 table list system to keep track of their data. Looking at the table below, identify the separate entities and attributes and design a logical level Entity Relationship Diagram for this company. Project Code PC010 PC010 PC010 PC011 PC011 PC011 PC012 Project Name Project Project Employee Employee Department Department Hourly Manager Budget No. Name No. Name Rate Mr. Ajay 120500 Database 21.00 Mr. Ajay 120500 S101 Mr. Ajay 120500 PC012 Reservation System Reservation System Reservation System HR System HR System PC012 Attendance System Attendance HR System System Attendance System Mrs. Charu Mrs. Charu Mrs. Charu Mr. Rajesh Mr. Rajesh Mr. Rajesh 500500 500500 500500 710700 710700 710700 $100 S102 S103 S104 S315 S137 S218 $109 Mohan Vipul Riyaz Pavan Jitendra Pooja Rahul Avneesh Vikas D03 D02 D01 D03 D02 D01 D03 D02 D01 Testing IT Database Testing IT Database Testing IT 16.50 22.00 18.50 17.00 23.50 21.50 15.50 20.50