Milestone : Algorithm for Problem 2

• Before any changes are made to the queries, fully qualify each attribute of the query with the current location.

• Perform the relational synthesis using the algorithm for Problem 1 while keeping the original set of location information

• After successful decomposition of unversal relation R and set of functional dependencies F to produce D, trickle the changes of location down to the queries

• The attributes in the SELECT clause are pointed to the correct location