Consider the relation schema LICENSE(License_id primary key, Fname, Lname, City, Phone, Age). An expression in relational algebra to find out license id, city and phone number of license holder whose first name starts with an A and is above 20 years of age can be

Question

Answer

Pi license_id, city, phone (Sigma fname like 'A%' and age > 20 (license))

Answer

Sigma fname like 'A%' and age > 20 (Pi license_id, city, phone, fname, age (license))

Answer

All of these

Answer

Pi license_id, city, phone (Sigma age > 20 (license) intersect Sigma fname like 'A%' (license))

Crowdly

Consider the relation schema LICENSE(License_id primary key, Fname, Lname, City,...

Want instant access to all verified answers on moovit.vit.ac.in?