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

Write the suitable SQL statement to answer the following questions based on the following tables ( image )the question is:3. Change EMPLOYEE (EMP_ID= 505) SALARY to 70000.

Execute a SQL statement to add a check constraint to the field mode_of_payment with values ('D', 'R' or 'C") in order_db

Consider the following expressions, which use the result of a relational algebra operation as the input to another operation. For each expression, explain in words what the expression does. a. year 2009 (takes) ▷ student b. year 2009 (takes ▷ student) C. ID.name, course_id (student takes)

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