Question

View 3

Seneca Courses Inc.

Employee Forms

All employee information for SCI is maintained on file forms. The following are sample employee information forms:

EMP_ID	7839		EMP_ID	7654
EMP_NAME	JOHN CHIU		EMP_NAME	ANDRE MARTIN
SOC_INS	123-234-345		SOC_INS	678-345-123
POSITION	MANAGER		POSITION	SALES
SUPERVISOR			SUPERVISOR	JOHN CHIU
HIREDATE	November 13, 1999		HIREDATE	September 24, 1999

EMP_ID	7434		EMP_ID	7435
EMP_NAME	PARVEZ RAI		EMP_NAME	DANIEL CHOY
SOC_INS	234-123-432		SOC_INS	345-312-234
POSITION	SALES		POSITION	CLERK
SUPERVISOR	JOHN CHIU		SUPERVISOR
HIREDATE	June 24, 1980		HIREDATE	August 4, 1998

Business Rules:

1. SOC_INS must always be different for each employee.

2. EMP_NAME must always have a value.

Normalize the above user view. Document all steps including UNF, 1NF, Dependencies, 2NF, and 3NF and explain or list the primary key and foreign

Answer 1