Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you guys help me, it needs to be in Relational Algebra Using the attached relational model, make correct relational algebra expressions that retrieve the
Can you guys help me, it needs to be in Relational Algebra
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 priceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started