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.