Question 11. Write the SQL statement that will implement the relational algebra expressions in the following relational algebra expressions RESULTI E O(discount_percent=30 RESULTIproduct_id=product_idORDER_ITEMS - RESULT2Morder_id=order_idORDERS RESULT3Acustomer_id=customer_idCUSTOMERS Tfirst_name.last_name,product_name(RESULT4) »(PRODUCTS) RESULT2 RESULT3 RESULT4 RESULT

Express the following SQL code in Relational Algebra form.SELECT *FROM COURSEWHERE (COURSE.COLLEGE <> ’Business’OR COURSE.COLLEGE <> ’Engineering’)AND COURSE.CREDIT = ’U’;

Based on SQL query knowledge

Based on the following authorication commands (ordered from 1 to 4), which of the following privileges is true, assuming that Ali is the owner of the database? Order By Ali 1 2 3 4 Select one: Omar Ali Ali Command Grant Select on Employee to Omar with grant option; Grant Select on Employee to Samer with grant option; Grant Update on Employee to Omar with grant option; Revoke Select on Employee From Omar Cascade; a) Ali and Omar have Update privilege on employee Ali has select privilege on employee b) Ali and Omar have Update privilege on employee Omar and Samer have select privilege on employee elect c) Ali and Omar have Update privilege on employee Ali and Omar have select privilege on employee d) Ali and Omar have Update privilege on employee Ali, Omar and Samer have select privilege on employee