Question: Write a relational algebra expression that returns members name and the average number of days they borrowed books for Write a relational algebra expression that

 Write a relational algebra expression that returns members name and the

Write a relational algebra expression that returns members name and the average number of days they borrowed books for

Write a relational algebra expression that returns member names that on average borrow books for the longest period

Write a relational algebra expression that returns the staff names that served all the members

PLEASE ONLY use the following operators

Use G for aggregate function

average number of days they borrowed books for Write a relational algebra

Instructions Try to answer all the questions using what you have learned in class. Please make your query general not data related Staff Reservation SIR sName Joan Pam Greg biD mID sld Quantity numberOfDays Status b1 M2 s11 1 Closed b2 M3 s12 2 PassDue b2 M1 53 1 2 Closed s3 Member Book mID M1 mName Sam Paul Ron bID brittle numberOfCopy CategorybAuthor b1 Algorithm 2 Math Aline b2 Database 3 CS Sean b3 Gone with 4 Fiction John the wind Laura OPETY AV = # snu=X MMKX =

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!