Need help in designing

Databases
1

Hi , I am designing database for simple voting system.but i am confuse if this is correct…and also is my design for the tables are properly normalize?

These are the tables.

position_tbl
p_id                       autoincrement
p_desc    

candidates master
c_id                                      auto_increment
c_p_id
c_name
c_lastname
c_age



voting_tbl
c_id
vote_count

Thank you in advance.

2

can a single person be a candidate for more than one position? if so, you gots problems with this design

3

Hi r937,

No, only one position each person.