Let R be a function with the attributes the ABCD. Consider the conjunctive SQL query

The select x.B, z.D
The from R x, y, R R z where x.A=z.D and y.C=0 and x.B=y.B and z.B=5 and z.C=y.C

(I) the Construct the pattern corresponding to the query.
(ii) Is the pattern constructed in (I) minimal? (Explain)
(ii) Minimize the pattern (I) in knowing that the query is only applied to the databases satisfying the FD s
'A, D, CD -> B, C -> A.
Show the intermediate steps.


(iii) constructed from the minimized the pattern a corresponding minimized SQL query.

Big problem solving with explanation, gratitude endlessly.