Project Management Report

Project Code: PR$001$

Project Title: Human Resource System

Project Manager: Alexander Jimskie Project Budget: $$200000$

EmployeeID Employee Name Department No Department Hourly Rate

E$0001$ Clara Miller $1$ IT $$100$

E$0002$ Sarah Lim $2$ Finance $$50$

E$0003$ Dorothy Jabines $1$ IT $$75$

E$0004$ Sham Moh $3$ HR $$60$

E$0005$ Philp Kohler $3$ HR $$50$

E$0006$ Nancy Vale $2$ Finance $$150$

E$0007$ Christy John $1$ IT $$120$

E$0008$ Mary Kone $1$ IT $$200$

Task $1$ Convert the Report from un$-$normal form into third normal form. Provide appropriate

name for each Entities and attributes. Find the primary, Foreign and composite keys. $12$ Marks

Note:

$$ Find Un$-$Normalized form data

$$ Convert un$-$normalized set to $1$NF

$1$NF to $2$NF

$2$NF to $3$NF

$$ In between the process of normalization find out Primary, foreign and Composite keys.

$$ Discuss the steps of normalization while carrying each NFs$.$

$$ Use appropriate tool to do the task