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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!