Normalize the following information into 3rd Normal Form, also indicate the Prim

Question

Normalize the following information into 3rd Normal Form, also indicate the Primary Key attribute(s) for each entity. The step-by-step solution must be provided to earn credit. Business Rules: Each employee must have a unique EMP_ID assigned, and can only work at one department at a time. Each employee could have multiple skills developed by working on different type of jobs (SKILL_NAME). EMP_ID (PK) , EMP_NM, DEPT_CD (PK), PHONE1 , PHONE2 , PHONE3 , DEPT_NM, SKILL_CD, SKILL_NM, SKILL_YRS 1. First Normal Form: To remove repeating group 2. Second Normal Form: To remove partial dependency 3. Third Normal Form: To remove transitive (hidden) dependency

Explanation / Answer

Convert first normal form into the 2NF format by

Writing each key component on a separate line, and then writing the original key on the last line and

Writing the dependent attributes after each new key.

So the tables eliminated into

Taking the employee details in a employee table and department details in a department table. One employee can only work at one department at a time

EMPLOYEE (EMP_ID, EMP_NM, PHONE1, PHONE1, PHONE2, PHONE3, DEPT_C)

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.