please answer the following question. Please provide step by step solution to each problem please

1)

2)

3)

4)

Subject: Design Of Database

Note: please answer this question with full solutions please and Thanks

Consider the following SQL query for the University example: SELECT facName, schedule SELECT facName, schedule FROM Faculty, Class. Enrll. Student WHERE astNameBurns' AND firstNameEdward' AND Class.classNumber nor AND Facul ty.factd - class. factd AND Student. stuta a. Write an initial relational algebra expression for this query. Enroll.classNumber AND Faculty.facld-Class.facId AND Student.stuld - Enroll.stuld: b. Using equivalences of relational algebra expressions, rewrite your relational algebra expression in a more efficient form, if possible. Explain why the new expression is efficient