I list the name and comments of all renters who have viewed


Consider the following relations

RENTER(rno, fname, lname, address, tel_no, pref_type, max_rent)

VIEWING(rno, pno, date, comment)

PROPERTY_FOR_RENT( pno, street, area ,city, pcode, type, rooms, rent)

Express the following queries in relational algebra.

(i) List the name and comments of all renters who have viewed a property.

(ii) Identify all renters who have viewed all properties with three rooms.

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: I list the name and comments of all renters who have viewed
Reference No:- TGS01657866

Now Priced at $20 (50% Discount)

Recommended (94%)

Rated (4.6/5)