Hi
I'm having troubles designing the tables for an organisational database.
I have 3 tables Division, Dept and Section, in a hierarchy order. ie, there are 7 Divisions, multiple departments in a division and multiple sections in a department. I have added these relationships by including the appropriate foreign keys. Each division, department and section have ID numbers which I have used as the primary keys.
My problem is that management might decide to add a new department or section, but still retain the same numbering for the rest. The number order is critical because it dictates the flow of work.
How am I able to insert a new field into a table without disturbing the other records in the same table and changing the foreign key numbers in related tables?
E.g if a new section 19 is added, all the sections from 19 onwards will have to change their ID's.
Thanks in advance.
I'm having troubles designing the tables for an organisational database.
I have 3 tables Division, Dept and Section, in a hierarchy order. ie, there are 7 Divisions, multiple departments in a division and multiple sections in a department. I have added these relationships by including the appropriate foreign keys. Each division, department and section have ID numbers which I have used as the primary keys.
My problem is that management might decide to add a new department or section, but still retain the same numbering for the rest. The number order is critical because it dictates the flow of work.
How am I able to insert a new field into a table without disturbing the other records in the same table and changing the foreign key numbers in related tables?
E.g if a new section 19 is added, all the sections from 19 onwards will have to change their ID's.
Thanks in advance.
