Minor project on Data Dictionary

Question 1 : Create a employee table?

FIELDS	Data type
Employee id	Your wish
First name	Your wish
Last name	Your wish
Health plan	NUMC, length 4

Question 2 : Create a Heath table?

Field Name	Key	Data Element	Domain	Type	Length
PLAN ID	X	YXXHLTHPLN	YXXHLTHPLN	NUMC	4
DESCR		YXXDESCR	YXXDESCR	CHAR	80
ANN PREM		YXXANNPREM	YXXANNPREM	DEC	6

Question 3 : Create a Hourly table?

Field Name	Key	Data Element	Domain	Type	Length
EMP ID	X	YXXEMPID	YXXEMPID	CHAR	10
HOUR RATE		YXXHOURRAT	YXXHOURRAT	NUMC	4

Note: - Hourly employees are always paid between Rs5.00 and Rs35.00 per hour. Explicitly list this restriction in the domain(value ranges) for the hourly rate.

Question 4 : Create a salary table?

Field Name	Key	Data Element	Domain	Type	Length
EMP ID	X	YXXEMPID	YXXEMPID	CHAR	10
SALARY		YXXSALARY	YXXSALARY	DEC	8

Question 5 : Create a Partner table?

Field Name	Key	Data Element	Domain	Type	Length
EMP ID	X	YXXEMPID	YXXEMPID	CHAR	10
NUM_SHARES		YXXNUMSHAR	DEC7	pre-defined	pre-defined

Question 6 : In Health table for field employee id use employee table as value table?

Question 7 : In Employee table for field HEALTH PLAN use health table as value table?

Question 8 : Establish foreign key relationship between Employee table and hourly table?

Question 9 : Establish foreign key relationships between tables?

Question 10 : Create a ADDRESS structure?

Field Name	Data Element	Domain	Type	Length
ADDR1	YXXADDR1	CHARS50	Pre-defined	Pre-defined
ADDR2	YXXADDR2	CHARS50	Pre-defined	Pre-defined
CITY	YXXCITY	CHAR50	Pre-defined	Pre-defined
REGION	YXXEGION	CHAR10	Pre-defined	Pre-defined
POST CODE	YXXPOSTCD	CHAR15	Pre-defined	Pre-defined
COUNTRY	LAND1_GP	Pre-defined	Pre-defined	Pre-defined

Note: - include this structure in the Employee table

Question 11 : Create a View to read the data from all the above mention tables?

Question 12 : Create a elementary search help for employee id field of table employee table?

Question 13 : Assign this created search help to ID filed of table partner table?

Question 14 : Creates TMG for all the tables?

Question 15: In Employee table , created on field should be Automatically filled with Todays date.