Milestone : Information Required

Need to keep track of where each attribute in the universal relation R = {A1, A2, ..., An} is actually located in terms of which table it is related to.
We can get this information from the system catalog
Now, from our definition of Problem 1, we remember that with the addition of a new functional dependency, we have to re-synthesize by using algorithms to decompose the universal relation schema R into D, the decomposition of R.
By just adding a small data structure to the current system catalog, we can keep track of the new assignments of location to the attributes.

Need to keep track of where each attribute in the universal relation R = {A1, A2, ..., An} is actually located in terms of which table it is related to.