Normalize the database below 1. Explain the structure of the table in the First Normal Form....

Transcribed Image Text:

Normalize the database below 1. Explain the structure of the table in the First Normal Form. 2. Draw a dependency diagram that shows all functional dependencies in the relation, based on the sample data shown. 3. Develop a set of relations in the Second and Third Normal Forms. Create your solution in app.diagrams.net online tool, save your solution as an image, insert the image in this MS Word file and Task. The table below represents the following information: Information about a project: a project code, a project name, a project manager name and a project budget Several employees can work on a project. The table stores an employee number, an employee name, an employee's department number and a department name, and an employee's hourly rate. Project Project Project Project Employee Employee Department Department Hourly Code No. Name No. Name Rate Name Manager Budget PC010 Reservation Mr. Ajay 120500 System $100 Mohan D03 Database 21.00 PC010 Reservation Mr. Ajay System PC010 Reservation Mr. Ajay System PC011 HR System Mrs. Charu PC011 HR System Mrs. Charu PC011 HR System Mrs. Charu PC012 Attendance Mr. Rajesh System 500500 500500 500500 710700 $137 710700 PC012 Attendance Mr. Rajesh 710700 $109 System 120500 $101 Vipul 120500 $102 Riyaz $103 Pavan $104 Jitendra $315 Pooja Rahul PC012 Attendance Mr. Rajesh System $218 Avneesh Vikas 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 Normalize the database below 1. Explain the structure of the table in the First Normal Form. 2. Draw a dependency diagram that shows all functional dependencies in the relation, based on the sample data shown. 3. Develop a set of relations in the Second and Third Normal Forms. Create your solution in app.diagrams.net online tool, save your solution as an image, insert the image in this MS Word file and Task. The table below represents the following information: Information about a project: a project code, a project name, a project manager name and a project budget Several employees can work on a project. The table stores an employee number, an employee name, an employee's department number and a department name, and an employee's hourly rate. Project Project Project Project Employee Employee Department Department Hourly Code No. Name No. Name Rate Name Manager Budget PC010 Reservation Mr. Ajay 120500 System $100 Mohan D03 Database 21.00 PC010 Reservation Mr. Ajay System PC010 Reservation Mr. Ajay System PC011 HR System Mrs. Charu PC011 HR System Mrs. Charu PC011 HR System Mrs. Charu PC012 Attendance Mr. Rajesh System 500500 500500 500500 710700 $137 710700 PC012 Attendance Mr. Rajesh 710700 $109 System 120500 $101 Vipul 120500 $102 Riyaz $103 Pavan $104 Jitendra $315 Pooja Rahul PC012 Attendance Mr. Rajesh System $218 Avneesh Vikas 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