1. Write a relational algebra query to return all rows (tuples) of Vehicle table in which Ma = Suzuki

2. Write a relational algebra query to return only the Ma and Mo of Vehicles with Ma = VW

3. Using the full table of the handout write the result of the query Vehicle.Ma, Own.SSN ( Vehicle.Color = 'Green'(Vehicle Own))

Here i am providing table

Giving the following relational schema and tables Vehicle (VRN, Ma, Mo, Color), Own (VRN, SSN) , Person (SSN, Name, Addr, Phone) Vehicle Own Person VRN Ma Mo Color VRN SSN SSN Name Addr Phone 123 Honda Hawk Red 123 bcd abc Dave Birch xxx 234 Mazda RX7 Blue 234 abc bcd Mary Grove yyy 345 Ford Taurus Blue 457 xyz cde Sriram Oak zzz 457 Ford Range Green 567 gha def Fang Birch www 567 Honda Accord Red 683 def efg Derek Elm uuu 678 Mazda RX7 Silver 795 abc fair Jason Elm vvv 789 VW Bug White 901 bcd ghi Xie Oak sss 890 Suzuki Intruder Black 789 uona hij Gilford Birch ttt 901 Harley Sportster Black 122 VW Bug Red

subject: DBMS