what is Flat Hierarchy in SQL?

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.

Hi Inathi Gqola,

                           Thanks for your support 

                            If the user having 4 children known as Flat Table...Right..? 

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.