Answered step by step
Verified Expert Solution
Question
1 Approved Answer
g. Price QUESTION 02: (20 Marks) The Database Library System is intended to Automate the library activities such as creating a new borrower, giving books
g. Price QUESTION 02: (20 Marks) The Database Library System is intended to Automate the library activities such as creating a new borrower, giving books to the borrowers, maintaining the details of all the item that were available in the books Implement the following task in Mongodk: (4Marks) 1. Create a table for Book Details 2 Book Title b. Language c Binding Id d. No.Copies Actual e NoCopies. Current f Publication year Boccower Details a Bortover Id b. BookId C Borrowed. From d. Borrowed.TO e Actual Return. Date f Issued by Student Details 2. Students b. Student Name c. Gender d Date of Birth Borrower Id f Department contact Number a) Insert 5 record on each table. ( 16Marls) b) Write a query to update publication year to 2018 if language is English (1Marks) c) Write a query to get sorted record with respect to Title and Language.( 1Marks) d) Write a query to get records of all books whose prices are greater than 5000 and less than 9000 (2Marks) e) Write a query to get record of all students who borrowed books.( 2Marks) ) Write a query to Inserts the value to an array in the resulting document but does not create duplicates. IMarks) 2) Write a query to find average and max price of book(1Marks) h) Write a query to find total students who borrowed books (1Marks) 1) Write a query to get record with respect publication year in ascending order(1Marks)
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