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