How many child tables are possible to create based on one parent table

Questions by yessuresh

Showing Answers 1 - 5 of 5 Answers


  • Mar 25th, 2014

There is no limit. Actually, the more tables use the parent table for reference the better. Tables that could be used across business areas in an EDW are called conform dimensions.


  • Apr 23rd, 2014

There is no limit

  Was this answer useful?  Yes

Shahbaz Bhatti

  • Oct 22nd, 2014

Minimum one child with parent table is required to create the parent-child relationship

  Was this answer useful?  Yes


  • Jan 27th, 2015

n-1 , where n is the number of attributes of the table

  Was this answer useful?  Yes

Sergey Alentyev

  • Mar 29th, 2015

If this exercise is part of normalization process then number of possible child tables is equal to number of determinants in the parent table that are non-key.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions