1. Write a relational algebra query to return all rows (tuples) of Vehicle table

Question

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

Explanation / Answer

1)Answer:

Relational algebra is a procedural query language, which takes instances of relations as input and yields instances of relations as output. It uses operators to perform queries. An operator can be either unary or binary. They accept relations as their input and yield relations as their output. Relational algebra is performed recursively on a relation and intermediate results are also considered relations.

our given question is Write a relational algebra query to return all rows (tuples) of Vehicle table in which Ma = ‘Suzuki’  

so answer is mentioned below.

Ma=‘Suzuki’ (Vehicle)

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.