Data Dictionary New

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Data Dictionary New as PDF for free.

More details

  • Words: 255
  • Pages: 4
DATA DICTIONARY Employee Attribute Name

Description

Data Type

L ength

Required (Yes/No)

Emp_ID

Unique ID # of Employee

Text

6

Yes

L_Name

Last name of Employee

Text

20

Yes

F_Name

First name of Employee

Text

20

Yes

Age

Age of Employee

Text

2

Yes

Sex

Gender of Employee

Text

1

Yes

Contact_No.

Contact No. of Employee

Text

15

No

Position

Position of Employee in Text

30

Yes

-

Yes

the company Photo

Image of the Candidate

OLE Object

Votes Emp_ID

Unique ID # of Employee

Ballot_No.

A Ballot box or storage box that contains votes

Text

6

Yes

Integer

3

Yes

Constraints Primary key

Votes Details Ballot_No.

A Ballot box or storage box that contains votes

Candidates_Info

Integer

Yes

100

Yes

50

Yes

Information about the running candidate on his/her position Text

Position

3

Position where the candidates where allocated

Text

Candidates Emp_ID

Unique ID # of Employee

Text

6

Yes

L_Name

Last name of Employee

Text

20

Yes

F_Name

First name of Employee

Text

20

Yes

Age

Age of Employee

Text

2

Yes

Yrs_of_Service

Years of servicing in his/ Date

2

Yes

Text

300

Yes

Text

150

Yes

her position Attainments Trscpt_of_records

Transcript of record of the running candidate

Awards

Special awards & talents, received

Position Position_Name

A position where the candidate is running

Candidate_No

Text

50

Yes

unique candidate number Text

10

Yes

15

Yes

a number is given each

Administrator Password

Encrypted password is needed before you can can the system

Tallied_votes

Total votes of each candidates and its already sorted..

Text

Related Documents

Data Dictionary New
November 2019 15
Data Dictionary
June 2020 7
Data Dictionary
November 2019 16
Data Dictionary
October 2019 18
Oracle Data Dictionary
November 2019 13