what is Flat Hierarchy in SQL?

Question

What is Flat Hierarchy in SQL?

Inathi Gqola · Answer

Hi Deepak, No it is not that... It is having all your records in one table therefore not having a relational database. Have a look at this link for a better understanding of what normalization is. ... Think of it like this; if you take all the tables in your database and combine them into one table.

Deepak Ratan · Answer

Hi Inathi Gqola , Thanks for your support If the user having 4 children known as Flat Table...Right..?

Inathi Gqola · Answer

Hi Deepak, You know when you have one table for everything? Example ; USER(userID, userName, userFavProgrammingLanguage, userDOB, userEmail1, userEmail2, userNumOfChildren, userChild1, userChild2, userChild3, userChild4) My example above is of what is known as a flat 'TABLE'. It is not normalized (UNF). It is BAD, for instance what happens if the user has 4 children. I know not what a 'flat hierarchy' is but I have a feeling its just another way of referring to a flat table. Let us wait and hear what the other guys have to say.

what is Flat Hierarchy in SQL?

Answers (3)