BT2201
Activity (3 items x 10 points)
Transform the table into 1NF, 2NF, and 3NF.
1NF
EmpID Name Manager Dept Code Dept Dependen Dependent
t
285 Carl Cruz Reyes Sales 1 Sales
365 Leo Lino Santiago Marketing 2 Marketing
458 Ron Ramos Velasco HR 3 HR 10 Kim
458 Ron Ramos Velasco HR 3 HR 20 Jeff
458 Ron Ramos Velasco HR 3 HR 30 Lisa
458 Ron Ramos Velasco HR 3 HR 40 John
2NF
Employee Manager
EmpID Name Manager ID Manager
285 Carl Cruz 11 Reyes
365 Leo Lino 22 Santiago
458 Ron Ramos 33 Velasco
Dept Dependents
Dept Code Dept Dependent Code Dept
Sales 1 Sales Sales 1 Sales
Marketing 2 Marketing Marketing 2 Marketing
HR 3 HR HR 3 HR
3NF
EmpID Manager ID Dependent Code Dependent ID
285 11 Sales 1
365 22 Marketing 2
458 33 HR 3 10
458 33 HR 3 20
458 33 HR 3 30
458 33 HR 3 40
This study source was downloaded by 100000850872992 from CourseHero.com on 04-20-2023 09:50:04 GMT -05:00
https://www.coursehero.com/file/141096382/05-Activity-1-Malapitan-Jhaninedocx/