05 Activity 1_Malapitan-Jhanine - STI College (multiple campuses) BSIT BSIT201

Jhanine Joyce C. Malapitan April 08,2022
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/