I have a scenario similar to this: Customer has Orders. Order has Details. Detail has Children. Child has grandChildren.

Given the above objects i am wondering if i create one denormalized table called

CustOrdDetChildGrand

and have variables CustID,OrderID,DetID,ChildID,GrandChildID,other columns

is better than have one table for each entity? What are the disadvantages in the long run that i would have with the above process? I am thinking of building custom business objects from the above denormalized table which represent the above object model. Please advise if you have an idea. Will appreciate it really. Thanks.