- Given The Library Db Schema In Below Answer The Following 1 Find Books Issued In 2015 2 Find Book Isbn And Name For 1 (100.43 KiB) Viewed 242 times
My dear friend, I ask you to solve all the parts completely and
correctly, and I do not want duplicate
answers
Take full time.
note: This is the second time that the question has spread, and
the solution is the same both times, and the solution is wrongNote:
This is the second time that the question has spread, and the
solution is the same both times, and the solution is wrong
I need full Answer .
dear sir Thank you very much.
Given the library DB schema in below, answer the following: 1- Find books issued in 2015 2- Find book isbn and name for books that belong to category 8 3- Find customer name for customers living in Amman 4- Find customer ID for customers who did not return books 5- Find isbn and copyNum for books that are returned late 6- Find isbn and copyNum for books that are returned early 7- Find isbn and copyNum for books that are returned on time 8- Find isbn for books that are distributed to branches with quantity greater than 100 copies 9- Find all books ordered alphabetically based on their title 10- Find all books ordered in descending order based on issue Year and if issue Year is equal for books, then order them alphabetically based on their title branch brid employee address eid name salary brid customer cid name address book isbn title issue issueyear catid pid bookcopy isbn copyid publishe Pid brid name category catid author aid name name write isbn distribute pid isbn ald brid dist Date quantity borrow cid isbn copyid borrowdate expectedReturnDate actualRetumDate