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 physical level Entity Relationship Diagram for this company.

Transcribed Image Text:

Project Project Name Code PC010 Reservation System PC010 Reservation System Reservation System PC011 HR System PC011 HR System HR System PC011 PC012 Attendance PC010 System PC012 Attendance PC012 System Attendance System Project Project Employee Employee Department Manager Budget No. Name No. 120500 $100 Mr. Ajay Mr. Ajay Mr. Ajay Mrs. Charu Mrs. Charu Mrs. Charu Mr. Rajesh Mr. Rajesh Mr. Rajesh 120500 $101 120500 $102 500500 $103 500500 $104 500500 $315 710700 $137 710700 $218 710700 $109 Mohan Vipul Riyaz Pavan Jitendra Pooja Rahul Avneesh Vikas D03 D02 D01 D03 D02 D01 D03 D02 D01 Department Hourly Name Rate Database 21.00 Testing IT Database Testing IT Database Testing IT 16.50 22.00 18.50 17.00 23.50 21.50 15.50 20.50 Project Project Name Code PC010 Reservation System PC010 Reservation System Reservation System PC011 HR System PC011 HR System HR System PC011 PC012 Attendance PC010 System PC012 Attendance PC012 System Attendance System Project Project Employee Employee Department Manager Budget No. Name No. 120500 $100 Mr. Ajay Mr. Ajay Mr. Ajay Mrs. Charu Mrs. Charu Mrs. Charu Mr. Rajesh Mr. Rajesh Mr. Rajesh 120500 $101 120500 $102 500500 $103 500500 $104 500500 $315 710700 $137 710700 $218 710700 $109 Mohan Vipul Riyaz Pavan Jitendra Pooja Rahul Avneesh Vikas D03 D02 D01 D03 D02 D01 D03 D02 D01 Department Hourly Name Rate Database 21.00 Testing IT Database Testing IT Database Testing IT 16.50 22.00 18.50 17.00 23.50 21.50 15.50 20.50

Answer rating: 100% (QA)

This is a physical Entity Relationship Diagram It has been divided into three tables name... View the full answer