This is a simple list table of a company trying to keep track of employee assignment to company protects (In other words, not a database but a flat one table file). You will design a database for this...


This is a simple list table of a company trying to keep track of employee assignment to company<br>protects (In other words, not a database but a flat one table file). You will design a database for this<br>company so that they won't be retying on a simple I table list system to keep track of their data<br>Looking at the table below, produce the 3Nf of the data<br>Normalize to the first three normal forms<br>Project<br>Project<br>Project<br>Project Employee Employee Department Department Hourly<br>Manager Budget<br>Name<br>Reservation Mr. Ajay<br>System<br>Reservation Mr. Ajay<br>System<br>Reservation Mr. Ajay<br>System<br>HR System<br>HR System<br>HR System<br>Code<br>Budget<br>No.<br>120500 S100<br>Name<br>No.<br>Name<br>Rate<br>PC010<br>Mohan<br>D03<br>Database<br>21.00<br>PC010<br>120500 S101<br>Vipul<br>D02<br>Testing<br>16.50<br>PC010<br>120500 S102<br>Riyaz<br>D01<br>IT<br>22.00<br>500500 S103<br>500500 S104<br>500500 S315<br>710700 S137<br>PC011<br>Mrs. Charu<br>Pavan<br>D03<br>Database<br>18.50<br>Jitendra<br>Pooja<br>PC011<br>Mrs. Charu<br>D02<br>Testing<br>17.00<br>PC011<br>Mrs. Charu<br>D01<br>IT<br>23.50<br>PC012<br>Attendance<br>Mr. Rajesh<br>Rahul<br>D03<br>Database<br>21.50<br>System<br>Attendance<br>PC012<br>Mr. Rajesh<br>710700 S218<br>Avneesh<br>D02<br>Testing<br>15.50<br>System<br>Attendance Mr. Rajesh<br>PC012<br>710700 S109<br>Vikas<br>D01<br>IT<br>20.50<br>System<br>

Extracted text: This is a simple list table of a company trying to keep track of employee assignment to company protects (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 retying on a simple I table list system to keep track of their data Looking at the table below, produce the 3Nf of the data Normalize to the first three normal forms Project Project Project Project Employee Employee Department Department Hourly Manager Budget Name Reservation Mr. Ajay System Reservation Mr. Ajay System Reservation Mr. Ajay System HR System HR System HR System Code Budget No. 120500 S100 Name No. Name Rate PC010 Mohan D03 Database 21.00 PC010 120500 S101 Vipul D02 Testing 16.50 PC010 120500 S102 Riyaz D01 IT 22.00 500500 S103 500500 S104 500500 S315 710700 S137 PC011 Mrs. Charu Pavan D03 Database 18.50 Jitendra Pooja PC011 Mrs. Charu D02 Testing 17.00 PC011 Mrs. Charu D01 IT 23.50 PC012 Attendance Mr. Rajesh Rahul D03 Database 21.50 System Attendance PC012 Mr. Rajesh 710700 S218 Avneesh D02 Testing 15.50 System Attendance Mr. Rajesh PC012 710700 S109 Vikas D01 IT 20.50 System

Jun 07, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here