Data Dictionary New
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
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
Data Dictionary Core Jm
June 2020 10