Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Relational algebra expression Staff Reservation SID S1 S2 S3 sName Joan Pam Greg Number bID mID sld Quantity numberOfDays Status 123 C01 Hd12 S1 1
Relational algebra expression
Staff Reservation SID S1 S2 S3 sName Joan Pam Greg Number bID mID sld Quantity numberOfDays Status 123 C01 Hd12 S1 1 Closed 124 CO2 Rf07 S1 2 PassDue 125 CO2 Rf07 53 2 Closed Member Book mlD M1 M2 mName Sam Paul Ron Laura bID bTittle numberOfCopy CategorybAuthor bi Algorithm 2 Math Aline b2 Database 3 CS Sean Gone with 4 Fiction John the wind M3 M4 b3 Question 1 (3 Points) Write a relational algebra expression that returns the name of the customer that borrowed a book titled 'Algorithm 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
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