Question: Question 1-5 using relational algebra, NOT SQL statement Consider the following relations and relationship: Property(propertyNo, ownerID, type, rent, address) Newspaper(newsPaperNo, name, street, city, zipCode, phoneNo)
Question 1-5 using relational algebra, NOT SQL statement
Consider the following relations and relationship:
Property(propertyNo, ownerID, type, rent, address)
Newspaper(newsPaperNo, name, street, city, zipCode, phoneNo)
Advertisement(propertyNo, newsPaperNo, date, cost)
1. List the propertyNo, ownerID, and addresses of all properties
2. List the propertyNo and address of all the properties whose rent is less than 1000.
3. List the maximum, minimum, and average rent of the properties.
4. List the propertyNo of all the properties' that have been advertised on "Houston Chronical".
5. List the names of all the newspapers where the properties with rent greater than 1000 have been posted.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
