Question: This is a Database (SQL) assignment can someone help me? Using the attached relational model, make correct relational algebra expressions that retrieve the desired data.
This is a Database (SQL) assignment can someone help me?

Using the attached relational model, make correct relational algebra expressions that retrieve the desired data. Use the notation used in class, including the correct special characters and subscripts where appropriate. Leave only the requested columns in your answer. Your solutions must be typed and turned in to Canvas as a PDF or a Microsoft Word document. 1. (10 pts) Find the name and rating of all hosts with a rating greater than 3. 2. (20 pts) Find the ID, first name, last name, and phone numbers of all guests with phone numbers. 3. (20 pts) Find the ID, name, city and description of all properties with a reservation price under $200. 4. (20 pts) Find the first and last name of all guests who have made a reservation at a property in the city of Folsom. 5. (30 pts) Find the ID, first name, and last name of all guests who do not have an email address. HOST RATING HOST_PHONE ID phone ID name guest-id host-id rating comment GUEST PROPERTY ID name city description ID first last GUEST_EMAIL GUEST_PHONE ID PHONE ID email RESERVATION r-id arrive leave prop-id prop-name guest-id price
Step by Step Solution
There are 3 Steps involved in it
To solve these queries using relational algebra well identify the tables involved and construct expr... View full answer
Get step-by-step solutions from verified subject matter experts
