Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a view call member_book that includes memberID, lastname, firstname, bookID, and title, that shows which member has borrowed which book, including currently and in
Create a view call member_book that includes memberID, lastname, firstname, bookID, and title, that shows which member has borrowed which book, including currently and in the past.
Use the view created above in to find the bookID and title of all the books checked out by John Smith in the past or currently.
Book(bookID, ISBN, title, author, publish-year, category) Member(memberID, lastname, firstname, address, phone-number, limit) CurrentLoan(memberID, bookID, loan-date, due-date) History(memberlD, 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 (it may differ for different members). The category of a book includes fiction, non-fiction, children's and reference. The CurrentLoan table represents the information about books that Cli Rantly 4hecksxl out. When the Innk is reiunkxl to the library, the iocon1 will be rcliknrxl iitiin 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. remove rom
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started