2 Replies - 126 Views - Last Post: 22 March 2019 - 09:05 AM Rate Topic: -----

#1 cwpark   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 22-March 19

Relational Algebra Help

Posted 22 March 2019 - 02:23 AM

Hi, I'm now studying relational algebra in DB
I have some questions about writing relational algebra.


I have relational schema here.
employee(empno, name, age)
book(isbn, title, author, publisher)
loan(empno, isbn, date)


and I need to write the queries in relational algebra.
(a) List employee names with book titles he/she have borrowed.
(B) Find book titles that employees over 50 years old have borrowed.


can anybody help me?

Is This A Good Question/Topic? 0
  • +

Replies To: Relational Algebra Help

#2 andrewsw   User is offline

  • quantum multiprover
  • member icon

Reputation: 6775
  • View blog
  • Posts: 27,938
  • Joined: 12-December 12

Re: Relational Algebra Help

Posted 22 March 2019 - 04:02 AM

What have you discovered or attempted? What is your question?
Was This Post Helpful? 0
  • +
  • -

#3 astonecipher   User is offline

  • Senior Systems Engineer
  • member icon

Reputation: 2791
  • View blog
  • Posts: 11,005
  • Joined: 03-December 12

Re: Relational Algebra Help

Posted 22 March 2019 - 09:05 AM

Translating SQL into the Relational Algebra
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1