subject

Consider a library database with the following schema (where primary keys are underlined):Book(bookID, ISBN, title, author, publish-year, category)Member(memberID, lastname, firstname, address, phone-number, limit)CurrentLoan(memberID, bookID, loan-date, due-date)History(memberID, bookID, loan-date, return-date)Members can borrow books from the library. The number of books they can borrow is limited by the "limit" field of the Member relation. The category of a book includes fiction, non-fiction, children’s and reference. The CurrentLoan table represents the information about books that are currently checked out. When the book is returned to the library, the record will be removed from CurrentLoad relation, and will be inserted into History relation with the return-date. A library may have more than one copy of the same book, in which case each copy has its own bookID, but all copies share the same ISBN. Express each of the following tasks in relational algebra. a. Find the phone-number and address of James Baker. b. Find the last name and first name of the member who is currently borrowing a book for which the bookID is 120058.c. List the bookID, title and author of all the books that were borrowed in the past by James Baker. d. List the bookID and title of all the books that are either currently checked out or borrowed in the past by James Baker. e. Find the bookID and title of all the books that are not currently checked out.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 12:40
In a response of approximately 50 words, explain why it would be essential for the successful a/v technician to participate in additional coursework, presentations and seminars offered by equipment manufacturers as well as annual conferences attended by colleagues in the industry.
Answers: 1
question
Computers and Technology, 22.06.2019 23:30
What are some ways to use a range name in a formula? check all that apply. in the defined names group, click use in formula, and then select the desired name. begin typing the name in the formula, select a name from the autocomplete list, and use the arrow keys and tab key to enter the name in the formula. begin typing the formula, and then click and drag with the mouse to select the cells to include in the formula. right-click one of the cells in the range. click formula options, and use the dialog box to add the name.
Answers: 1
question
Computers and Technology, 23.06.2019 15:00
What is the total resistance in a circuit that contains three 60 ohm resistors connected in a series? a. 20 ohms b. 120 ohms c. 60 ohms d. 180 ohms
Answers: 2
question
Computers and Technology, 23.06.2019 22:30
Lakendra finished working on her monthly report. in looking it over, she saw that it had large blocks of white space. what steps could lakendra take to reduce the amount of white space?
Answers: 3
You know the right answer?
Consider a library database with the following schema (where primary keys are underlined):Book(bookI...
Questions
question
English, 01.04.2020 20:38
Questions on the website: 13722363