Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spatio Temporal Database Management International Workshop Stdbm 99 Edinburgh Scotland September 10 11 1999 Proceedings Lncs 1678

Authors: Michael H. Bohlen ,Christian S. Jensen ,Michel O. Scholl

1999th Edition

3540664017, 978-3540664017

More Books

Students also viewed these Databases questions

Question

Show that if ad - bc 0, then the reduced row-echelon form of 1 1

Answered: 1 week ago

Question

The company openly shares plans and information with employees.

Answered: 1 week ago