Hello,

I have to design a database for an office. They have division and section.

I thought of making 2 tables, division and section.

table division
division_id
division_name

table section
section_id
section_name
division_id

section_id is primary key and auto increment in section_table.
division_id is primary key and auto increment in division_table.

I want to know which is better here, should i have to remove division_id from division table and section_id from section table and put division_name instead of division_id, since division_name and section_name are unique?

db is mysql and language is PHP.

Thanks