The design of a RDBMS architecture maintains a logical level (Conceptual view) and a physical level (actual File storages) of a database Independently, which makes RDBMS thriving over rapid changes in complex modern enterprise database systems. Describe how this independence between a logical level and a physical level can be achieved in RDBMS by explaining how a view is maintained and a view query (that is a query with view) is processed in RDBMS using the following example Q1 and the view v1 below Create View v1 (x1, sum_y1) As
Select t1.x1, Sum(t1.y1)
From t1
Group By t1.x1:
1-1) Specify which subsystem of a SQL Server in the following is in charge of view processing mechanism? The subsystems of a SQL Server for query processing are: Syntaxer, Resolver, Optimizer, or File Execution subsystem.
1-2) Show the view processing mechanism how Q1 - the query with a view below is processed when the query Q1 is submitted to a RDBMS server. Assume that v1 is already created in the system and you can name the temporary table in the view processing as needed.
Q1: Select*
From v1. t2
Where v1.x1 = t2.x2 and v1.x1 > 10;
1-3) For the final processed query of Q1 in 1-2), build a query execution algorithm in Relational Algebra operators either in data pipelining steps (top to bottom) or a query execution tree (in a bottom up sequence) that will be built by the end of the Optimizer.

Define a class named movie. include private fields for the title, year, and name of the director. include three public functions withprototypes void movie: : settitle(cstring); , voidmovie: : setyear(int); , void movie: : setdirector(string); . includeanother function that displays all the information about a movie. write a main() function that declares a movie object namedmyfavoritemovie. set and display the object's fields. this is what i have but know its wrong since it will notcompile: #include#includeusing namespace std; //class declarationclass movie{private: string movietitle ; string movieyear; string directorname; public: void settitle(string title); void setyear(string year); void setdirector(string director); void displayinfo(); }; //class implementationvoid movie: : settitle(string title){ movietitle = title; cout< < "what is the title of themovie? "< > temp; myfavoritemovie. settitle(temp); cout< < "enter movie year"< > temp; myfavoritemovie. setyear(temp); cout< < "enter director'sname"< > temp; myfavoritemovie. setdirector(temp); //display all the data myfavoritemovie. displayinfo(); system("pause"); return 0; this code is not entirely mine someone on cramster edited my firstcode but then i try manipulating the new code and i still get acompile error message : \documents\visual studio 2008\projects\movie\movie\movie. cpp(46) : error c2679: binary '< < ' : no operator found which takes aright-hand operand of type 'std: : string' (or there is no acceptableconversion)c: \program files (x86)\microsoft visual studio9.0\vc\include\ostream(653): could be'std: : basic_ostream< _elem,_traits> & std: : operator< < > (std: : basic_ostream< _elem,_traits> & ,const char *)w