Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Basics Computer EngineeringInformation Warehouse Basics From Science

Authors: Odiljon Jakbarov ,Anvarkhan Majidov

1st Edition

620675183X, 978-6206751830

More Books

Students also viewed these Databases questions