Question

Describe in details about the basic concepts of object-oriented programming

Answer 1

Consider the following relations: Employee (E-ID, Name, P-ID) Project ( P-ID, E-ID, P- Cost, P-Profit) Consider the following query on these relations: List the E-ID, Name, P-Code and P-Profit whose E-ID is 2017001 3. (a) Represent the above query using SQL (b) Convert the SQL query into equivalent relational algebraic query (c) Draw the query treefor the above relational algebraic query (d) Using the query tree, transform the relational algebraic query to an equivalent relational algebraic query which may reduce the query evaluation cost.