Consider the relational database schema REGISTRATION (License_id, Car_id, Registered, primary key(License_id, Car_id)), CAR(Car_id primary key, Model, Year, Color). An expression in relational algebra to find out the license id of license holder and the model of the car owned by them can be

Question

Consider the relational database schema REGISTRATION (License_id, Car_id, Registered,  primary key(License_id, Car_id)), CAR(Car_id primary key, Model, Year, Color). An expression in relational algebra to find out the license id of license holder and the model of the car owned by them can be

Answer

Pi license_id, model (car * registration)

Answer

Pi license_id, model (registration)

Answer

None of these

Answer

Pi license_id, model (car)

Crowdly

Consider the relational database schema REGISTRATION (License_id, Car_id, Regist...

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