Results 1 to 3 of 3
Thread: designing db
Mar 31, 2011, 13:11 #1
- Join Date
- Feb 2007
- 0 Post(s)
- 0 Thread(s)
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.