Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

International Baccalaureate Computer Science HL And SL Option A Databases Part I Basic Concepts

Authors: H Sarah Shakibi PhD

1st Edition

1542457084, 978-1542457088

More Books

Students also viewed these Databases questions