Assume that you are working as a database administrator for a company named XYZ$.$ XYZ is a

prominent vehicle spare parts manufacturing company known for producing a wide range of

spare parts, including Headlights, Bumper $,$ Seats, Tires, Engines, and Breaks for popular car

brands such as Toyota, Honda, Suzuki, MITSUBISHI and Nissan. Some of the spare parts such

as engines, headlights and engines are delivered in pieces $($PCs$)$ while seats, tires and breaks

are delivered in sets. As part of your role, you are responsible for managing the company's

database to ensure optimal performance and facilitate seamless operations. Review and

understand the existing data schema of the spare parts database and perform join operation on

the following spare parts.

The Following are the two tables named COMPANY & Question Statement:

Students are required to apply the following Join Operations in the form of relational algebra

on given tables $$COMPANY and ITEM$$ and provide resultant tables.

i$.$

ii$.$

iii.

iv$.$

Theta Join on Company and Item tables having a condition Item$\_$Unit $=$ PCs

Equi join on Company and Item tables.

Natural join on Company and Item tables.

Semi join on Company and Item tables

Dos:

$$ Understand Relational Algebra Operations and perform joins.

$$ In solution, provide only relational algebra expression and resultant table for each type

of join.

Donts:

$$ SQL code for join operations is not required. ITEM.COMPANY

$\backslash$table$[[$Comp$\_$ID$,$Comp$\_$Name,Comp$\_$City,Comp$\_$Ph#$],[$C$001,$Toyota,Islamabad,$051-321002$