This repository contains the solution for the second home assignment in the Databases course (Shenkar College, IE&M).
The assignment focuses on the theoretical foundation of SQL: solving complex queries using Relational Algebra notation (Sigma, Pi, Join, Union, Difference).
- Relational Algebra Mastery: Demonstrating proficiency in using the fundamental set of nine Relational Algebra operators.
- Complex Query Translation: Converting advanced data retrieval requirements into precise algebraic expressions.
- Set Operations: Utilizing Union, Intersection, and Difference operators to combine query results.
- Theoretical Foundation: Proving a deep conceptual understanding of the Relational Model and its rules for data manipulation.
Relational_Algebra_HW2_Solution.pdf: Full PDF solution containing the algebraic expressions for all query requirements.Assignment_Instructions_2.pdf: Original assignment instructions.