top of page

Minor project on Data Dictionary

Updated: Feb 11

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.


39 views1 comment

Recent Posts

See All

1 Comment

Rated 0 out of 5 stars.
No ratings yet

Add a rating
Rated 5 out of 5 stars.

useful info

Like
bottom of page