Database System Complete Book: in this exercise we assume that we wish to save i

Question

Database System Complete Book: in this exercise we assume that we wish to save information to the country library network. The database is supposed to store information about books, libraries and members of the libraries. books(book-number, book-name, author, year) library(library-name, city, phone) purchases(library-name ,book-number, ordered) readers(reader-number, library-name, n-books, book-number) readerDetails(reader-number, reader-name ,address, phone) True/False In case that the input is wrong: Point the reason why? And suggest a way to fix it:

Explanation / Answer

1) The first query will successfully returns all writers name whose book was not ordered in any library. So this is correct.

2) The second query will return all the readers phone numbers who have loaned more than 100 books.

3) The third query will return all the readers names of New York library (any one).

So all three queries are correct to the best of my knowledge.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.