I have to design a database for an office. They have division and section.
I thought of making 2 tables, division and section.
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.