Consider the following database schema

5. (5 points) Consider the following database schema CarDesc (CarNo, Model, Color, Year) Review (Model, Review, Rating) Then consider the following views v, (N, M, Y) :-Car Desc(N, M, C, Y). C-' red' V2(N, M,Y): -CarDesc(N. M,C,Y),Y s 1970 v3(M, R) :-Review (M, Re, R), Re = 10 Show how to apply the bucket algorithm to rewrite the following query using the above views. 0(N. R):-CarDesc(N , M, C,Y), Review (M, Re, R), R = 10,Y 1970 5. (5 points) Consider the following database schema CarDesc (CarNo, Model, Color, Year) Review (Model, Review, Rating) Then consider the following views v, (N, M, Y) :-Car Desc(N, M, C, Y). C-' red' V2(N, M,Y): -CarDesc(N. M,C,Y),Y s 1970 v3(M, R) :-Review (M, Re, R), Re = 10 Show how to apply the bucket algorithm to rewrite the following query using the above views. 0(N. R):-CarDesc(N , M, C,Y), Review (M, Re, R), R = 10,Y 1970