Databases Week #3, Part #1 Normalization

Database Normalization Explanation o Super Key o Candidate Key o Primary Key o 1NF (emp_id, contact, phone numbers) o 2NF (emp_id, proj_id, proj_budget, proj_budget depends on proj_id) o 3NF (emp_id, dept_id, dept_location, dept_location depends on dept_location) o 3.5NF aka BCNF (Example emp_id, dept_id, manager, manager --implies-- dept_id) o 4NF (Example emp_id, skills, hobbies)