Designing Table to Record Hierarchy

[vhassan]

Hi, How we can design a database tables that record hierarchical data. The levels of hierarchy are not fixed. For example: Table Header: A B C D E F G SomeOtherHeader Respective record: 1 4 3 2 6 t a PK_of_Another_Table 2 3 4 6 8 y a PK_of_Another_Table Now the record has upto Level "G" with different values. But it can be up to different level for another block of record. So what is best relational implementation of this Dynamic Hierarchy? Please refer any link that is worth reading related to this topic. Thanks. Good Day.