First page Back Continue Last page Overview Graphics
Milestone : Algorithm for Problem 2(contd.)
The FROM clause is changed to be the union of the locations of the attributes in the SELECT clause
The WHERE clause of the query has the attributes pointing to the correct location and a JOIN on the X attribute has to be added given that X --> Y was the newly added functional dependency
A foreign key constraint must be added for the X attribute