Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Computer Engineering Expert

[Relational Algebra]

Write a relational algebra expression that will output first name and last name of computer science major male students who have borrowed books from "University of Iowa Main Library".

Relational Schema:

Book(ISBN:String, Title:String, Author:String, Category:String, Year:Integer)

Student(Student_Id:Integer, First_Name:String, Last_Name:String, Major:String, Gender:Char, DOB:Date)

Library(Library_Id:String, Library_Name:String, Library_City:String)

Book_Library(ISBN:String, Library_Id:String, Book_Id:Integer)

Borrow(Student_Id:Integer, Book_Id:Integer, Borrow_Date:Date, Return_Date:Date)

The schema above is a segment of a library database. It contains some basic information about books in different libraries and the students who borrow them.

In each relation, the key of the relation is underlined. The same book can be in many libraries. For example a network of libraries can have 5 copies of book "Tale of Two Cities". A library may also have several copies of the same book. ISBN is a unique ID assigned to a book. Book_Id is a unique ID assigned for a copy of the book by a specific library network.

The relation Book stores book ISBN, the book title, the author, the category it belongs to (e.g., Computer Science, Medicine) and year of publication.

The student table records the student's unique ID, the first name, the last name and some other information. The relation Library stores information about each of the libraries in a network of libraries.

Book_Library table records the books in a library with a unique ID for every copy of a book. The database keeps track of borrowing activity in relation Borrow. Date is of format "YYYYMMDD". If a book has not been returned than the "Return_Date" value will be NULL.

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M93108610

Have any Question?


Related Questions in Computer Engineering

How can deferred cancellation ensure that thread

How can deferred cancellation ensure that thread termination occurs in an orderly manner as compared to asynchronous cancellation?

What type of economic system does norway have explain some

What type of economic system does Norway have? Explain some of the benefits of this system to the country and some of the drawbacks

What is the role of arp and how does it cause a security

What is the role of ARP and how does it cause a security concern? What is the different between global and private IP addresses? How does using NAT change a private IP address into a global IP address, and why is this so ...

What is the role of arp and how does it cause a security

What is the role of ARP and how does it cause a security concern? What is the different between global and private IP addresses? How does using NAT change a private IP address into a global IP address, and why is this so ...

Rebecca borrows 10000 at 18 compounded annually she pays

Rebecca borrows $10,000 at 18% compounded annually. She pays off the loan over a 5-year period with annual payments, starting at year 1. Each successive payment is $700 greater than the previous payment. (a) How much was ...

Please respondwhat are some other ways to troubleshoot

PLEASE RESPOND What are some other ways to troubleshoot reduced speed or latency? Or to find out what is using all the bandwidth? Perhaps might incorporate parts of this into own three issues.

Sutures sutures are strands or fibers used to sew living

Sutures: Sutures are strands or fibers used to sew living tissue together after an injury or an operation. Packages of sutures must be sealed carefully before they are shipped to hospitals to prevent contamination. The p ...

You are given a test to enter graduate school you must

You are given a test to enter graduate school. You must select 10 of the 13 essay questions to answer to determine your writing skills. How many ways can you select those questions?

Sectools - top 125 network security toolssnort websitenmap

SecTools - Top 125 Network Security Tools SNORT website Nmap website Lynx website (for a text browser) Wget website Teleport Pro website Research one of the tools listed in the chapter or linked above. Discuss its releva ...

One of the basic motivations behind the minimum spanning

One of the basic motivations behind the Minimum Spanning Tree Problem is the goal of designing a spanning network for a set of nodes with minimum  total  cost. Here we explore another type of objective: designing a spann ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As