Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Staff Reservation si sName Joan Pam Greg Number bid MID sld Quantity numberOfDays Status 123 C01 Hd1251 1 Closed 124 CO2 Rf07 si 2 2
Staff Reservation si sName Joan Pam Greg Number bid MID sld Quantity numberOfDays Status 123 C01 Hd1251 1 Closed 124 CO2 Rf07 si 2 2 PassDue. 125 CO2 Rf07 53 1 2 Closed S2 Member Book mJR M7 mName Sam Paul M2 | bid brittle numberOfCopy CategorybAuthor bi Algorithm 2 Math Aline b2 Database 3 CS Sean b3 Gone with 4 Fiction John the wind Ron 25 Laura Question 1 (3 Points) Write a relational algebra expression that returns the name of the customer that borrowed a book titled 'Algorithm Question 2 (3 Points) Write a relational algebra expression that returns the name of members that never borrowed any book Question 3 (5 Points) Write a relational algebra expression that return the name of members that borrowed all the books available in the library Question 4 (5 Points) Write a relational algebra expression that returns the member's name that never borrowed any book authored by 'Aline Question 5 (5 Points) Write a relational algebra expression that return the member's name that borrowed at least 10 books so far (10 or more different books) Question 6 (5 Points) Write a relational algebra expression that returns the member's name that borrowed more 'fiction' books than 'math'. Question 7 (3 Points) Write a relational algebra expression that returns the name of librarians that assisted checkout books for 'Sam'. Question 8 (4 Points) Write a relational algebra expression that returns the staff's name that never served any member Question 9 (4 Points) Write a relational algebra expression that returns customer's name and the average number of days they borrowed books for Question 10 (4 Points) Write a relational algebra expression that returns the book category that 'Sam 'never borrowed Question 11 (5 Points) Write a relational algebra expression that returns customer names that on average borrow books for the longest period Question 12 (4 points) Write a relational algebra expression that returns the staff names that served all the members
Step 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