Analysis of DEPARTMENT_LKP:
• Since “Dept No” and “Dept Desc” values will be repeated for several records in EMPLOYEE_DTL table, you have to design this lookup for saving the disk space.
• You have to assign NOT NULL constraint for all columns since in general, lookups should not have null value.
• You have to assign “Dept No” as the primary key to validate the detailed data in EMPLOYEE_DTL table.

Sample Source Data

Entity Name	Table Name	Attribute Name	Column Name	Datatype	Null Option	P Key	F Key
Department Lookup	DEPARTMENT_LKP	Department Number	DPTMT_NUM	NUMBER(2)	NOT NULL	Yes	No
Department Lookup	DEPARTMENT_LKP	Department Description	DPTMT_DESC	VARCHAR2(50)	NOT NULL	No	No
Department Lookup	DEPARTMENT_LKP	DateTime Stamp	DTTM_STMP	DATE	NOT NULL	No	No

Please proceed to next page for continuation.

---

Sample Data Analysis: Continued...       Sample Data Analysis: Continued...

---