Scribd
Upload
28 views1 page

ch05 - Relational Algebra

The document outlines 5 queries for a relational algebra class activity, including listing property details with rents over 400, addresses of properties, addresses of properties with rents over 400, owners and their houses in Glasgow, and the monthly rental amount collected by each branch.

Uploaded by

Muhd Zikry Adib
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
28 views1 page

ch05 - Relational Algebra

The document outlines 5 queries for a relational algebra class activity, including listing property details with rents over 400, addresses of properties, addresses of properties with rents over 400, owners and their houses in Glasgow, and the monthly rental amount collected by each branch.

Uploaded by

Muhd Zikry Adib
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Class Activity: Relational Algebra

1. List all details of properties that have rents more


than 400.
2. Give only the address of properties.
3. Give the address of properties that have rents
more than 400.
4. List the owners who own houses in ‘Glasgow’.
Show the names of owners and details of their
houses.
5. Assuming the rent in the PropertyForRent is the
monthly rent, how much rental does each branch
collect in a month? Give the total monthy rent
column an alias.
1

You might also like