KEMBAR78
Data Dictionary Normal | PDF
Scribd
Upload
13 views2 pages

Data Dictionary Normal

The document provides a data dictionary for a database related to an election system, detailing the structure and types of various fields for Admin, Election, Voter, Party, and Candidate entities. Each entity includes field names, data types, and notes indicating primary and foreign key relationships. This structured information is essential for understanding the database schema and relationships between different entities.

Uploaded by

tamiruharege
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views2 pages

Data Dictionary Normal

The document provides a data dictionary for a database related to an election system, detailing the structure and types of various fields for Admin, Election, Voter, Party, and Candidate entities. Each entity includes field names, data types, and notes indicating primary and foreign key relationships. This structured information is essential for understanding the database schema and relationships between different entities.

Uploaded by

tamiruharege
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Data dictionary for data base

Admin

Field Name Type Notes


Username VARCHAR Primary Key
Password VARCHAR
Address TEXT
Email VARCHAR
Phone_no VARCHAR

Election

Field Name Type Notes


Election_id INT Primary Key
Title VARCHAR
Date DATE
Start_date DATE
End_date DATE

Voter

Field Name Type Notes

National_id VARCHAR Primary Key

State VARCHAR

Address TEXT

Age INT

City VARCHAR

Username VARCHAR

Party

Field Name Type Notes

Party_id INT Primary Key

Party_name VARCHAR
Leader_name VARCHAR

Image BLOB/URL

Candidate

Field Name Type Notes

Candidate_id INT Primary Key

First_name VARCHAR

Middle_name VARCHAR

Last_name VARCHAR

Image BLOB/URL

Party_id INT Foreign Key

Party

Party_id INT Primary key


Candidate_id Int FK

Admin

Field Name Type Notes

Username VARCHAR Primery key


National_id VARCHAR FK

Election_id INT FK

Party_id INT FK

You might also like