Question: 1 ) Use the scheme instance to answer the followings: ( Marks: 5 * 2 0 ) ( 1 0 for query, 1 0 for

1) Use the scheme instance to answer the followings: (Marks: 5*20)(10 for query, 10 for result)
Note: You should show the resulting relation!
1. List all the staff that has salary >9000 and =24000
2. Show all flats that owned by Carol Farrel
3. List all cities where there is either a branch or a property for rent 5. List all cities where there is a branch office but no property for rent
5. List names and comments of all clients who have viewed a property for rent
 1) Use the scheme instance to answer the followings: (Marks: 5*20)(10

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!