Using relational algebra operations Select, Project, Cartesian Product, Union, Intersection, Difference, Division, Left Outer Join, Right Outer Join, and Join, write 6 queries for your project database. Make sure to explain each step. For example:

Query1: (Query Description)

Step1: Find all…..

             SELECT ………..

Step2: combine ….. then extract …….

              PROJECT (……………….CARTESIAN PRODUCT )

Etc.

Submit a Word document or PDF with the following sections:

1. Introduction – Restate problem and bullet point a high level description of your queries. Why are these queries useful?
2. Entity-attribute-table for all entities as well as associative entities.
3. Your queries and step by step explanations
4. An updated ERD