Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

LuibraryBranch (hd bnalIl Bookloan(oid, lid,rid, dateOut, dueDate Readerizisd, name address, age, phone); Book Obid title, publisher) -B. Write the following queries in relational algebra: 7.

image text in transcribed
LuibraryBranch (hd bnalIl Bookloan(oid, lid,rid, dateOut, dueDate Readerizisd, name address, age, phone); Book Obid title, publisher) -B. Write the following queries in relational algebra: 7. Phint the sde and publisher of all book(s) loaned out from the Cape Town' branch 8. Print the name of branch(es) that either loaned out a book titled 'Casablanca Express' or loaned out any book to a reader named John Doe 9. Print the names of readers who checked out book(s) in EVERY library branch; 10. Print the name of reader(s) who checked out books from exactly FOUR library branches

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

More Books

Students also viewed these Databases questions