Transcribed Image Text: Below given relations of a database are in First Normal Form (1st NF)

Transcribed Image Text: Below given relations of a database are in First Normal Form (1st NF). Decompose (Split) the
relations to Normalize in 2NF and 3NF.
tbl Project
Project
Code
Project Name
Project Manager Budget
Reservation System
HR System
Attendance System
PC010
Mr. Said
25000
PC011
MS. Malak
32000
PC012
Mr. Rajesh
19000
DBMS
tbl Emp Dept
Project Code
Emp No
Hourly Pay
Emp Name Dept No Dept Name
Ali Mohd.
PC010
S100
D03
Database
7.500
PC010
S101
Hamood
D02
Testing
5.500
PC010
S102
Riyaz
D01
IT
8.200
PC011
S103
Pavan
D03
Database
6.500
PC011
S104
Basma
D02
Testing
5.400
PC011
S115
Asaad
D01
IT
7.900
PC012
S137
Fathima
D03
Database
6.200
PC012
S218
Avinash
D02
Testing
6.100
PC012
S109
Роoja
D01
IT
9.300

-25-


Buy plagiarism free, original and professional custom paper online now at a cheaper price. Submit your order proudly with us



Essay Hope