Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Staff Reservation SID S1 sName Joan Pam Greg S2 S3 Number bin mld sld Quantity numberOfDays Status 123 001 Hd1251 1 Closed 124 CO2 Rf07

image text in transcribed

Staff Reservation SID S1 sName Joan Pam Greg S2 S3 "Number bin mld sld Quantity numberOfDays Status 123 001 Hd1251 1 Closed 124 CO2 Rf07 S1 2 PassDue 125 C02 Rf07 S3 2 Closed Member Book mlDmName M1 Sam M2 Paul M3 Ron M4 Laura bID bTittle numberOfCopy CategorybAuthor bi Algorithm 2 Math Aline b2 Database 3 CS Sean b3 Gone with 4 Fiction John the wind 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 Staff Reservation SID S1 sName Joan Pam Greg S2 S3 "Number bin mld sld Quantity numberOfDays Status 123 001 Hd1251 1 Closed 124 CO2 Rf07 S1 2 PassDue 125 C02 Rf07 S3 2 Closed Member Book mlDmName M1 Sam M2 Paul M3 Ron M4 Laura bID bTittle numberOfCopy CategorybAuthor bi Algorithm 2 Math Aline b2 Database 3 CS Sean b3 Gone with 4 Fiction John the wind 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

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

Database Design And SQL For DB2

Authors: James Cooper

1st Edition

1583473572, 978-1583473573

Students also viewed these Databases questions

Question

What does the elimination process accomplish?

Answered: 1 week ago

Question

4 How the market system adjusts to change and promotes progress.

Answered: 1 week ago