Normai

N

Create a map(ERD) of entities and find all dependencies and remove them you should have another ERD with 1NF, 2NF, 3NF, and BCNF. (Normalization)

is used bjy managed by Employees employee_id (pk) employee name phone email address Tools product id (pk) product name product type Tool usage product id (fk) name Has StartTime EndTime tool_id (pk) rls made up of Employee Skills employee id (fk) skills id (pk) grade Makes Skills Type skills ld (fk) employee name type id(pk) skills type Employee status product id (fk) status id (pk) skills id (fk) work StartTime EndTime is used bjy managed by Employees employee_id (pk) employee name phone email address Tools product id (pk) product name product type Tool usage product id (fk) name Has StartTime EndTime tool_id (pk) rls made up of Employee Skills employee id (fk) skills id (pk) grade Makes Skills Type skills ld (fk) employee name type id(pk) skills type Employee status product id (fk) status id (pk) skills id (fk) work StartTime EndTime