(Solved) : Owner Relational Database Admin Created Following Relations Student Id Name Totalcredit De Q27986218 . . . .

An owner of a relational database (ADMIN)created the following relations:

STUDENT = (ID, NAME,TOTAL_CREDIT, DEP_NUMBER)

INSTRUCTOR = (ID,NAME, SALARY, DEP_NUMBER)

COURSES = (COURS_ID,TITLE, DEP_NUMBER, CREDITS)

DEPARTMENT =(DEP_NUMBER, BUILDING, BUDGET)

The ADMIN user wants to pass privileges to otheraccounts X, Y and Z. Write the correct SQL statements to grant thefollowing privileges.

1-Account X can retrieve or modify any relationexcept COURSES and can pass any of theseprivileges to other accounts.

2- Account Y can retrieve all the attributes ofSTUDENT and COURSES exceptTOTAL_CREDIT, DEP_NUMBER for bothrelations. [2 marks]

3- Account Z can retrieve any attribute ofINSTRUCTOR but only for those whom