Read the passage and answer the following questions:A School in Delhi uses database management system to store student details. The school maintains a database ‘school_record’ under which there are two tables.Student Table : Maintains general details about every student enrolled in school.StuLibrary Table : To store details of issued books. BookID is the unique identification number issued to each book. Minimum issue duration of a book is one Day.Identify the SQL Query which displays the data of StuLibrary table in ascending order of StudentID*1 pointSelect * from StuLibrary Order By BookID;Select * from StuLibrary Group By StuID;Select * from StuLibrary Order By StuID ASC;Select * from StuLibrary Order By StuID DESC;The Primary Key for StuLibrary Table is/are*1 pointBookIDBookID, StuIDBookID, Issued_dateIssued_dateWhich of the following SQL Query will fetch ID of those issued books which have not been returned?*1 pointSELECT BookID from StuLibrary where BookID is NULL;SELECT BookID from StuLibrary where StuID is NULL;SELECT BookID from StuLibrary where Issued_date is NULL;SELECT BookID from StuLibrary where Return_date is NULL;The Alternate Key for Student Table will be*1 pointStuNameStuContactStuAadharStuClassBackSubmitClear form

Possibility High School maintains a database containing tables related to its students and the subjects offered. Which of the following represents a table within the database?*1 pointa student's namea student's recordall the personal data on studentsthe age of a student

Consider the following schema for institute library: Student (Roll No, Name, Father_ Name, Branch) Book (ISBN, Title, Author, Publisher) Issue (Roll No, ISBN, Date-of –Issue) Write the following queries in SQL and relational algebra: List roll number and name of all students of the branch ‘CSE’. Find the name of student who has issued a book published by ‘ABC’ publisher. List title of all books and their authors issued to a student ‘RAM’. List title of all books issued on or before December 1, 2020.List all books published by publisher ‘ABC’.

Question 3In a bookshop database, the complete information about one specific book is referred to as a ______________.1 pointColumnTableRecord

A library system contains information for each book that was borrowed. Each time a person borrows or returns a book from the library, the following information is recorded in a database.Name and the unique ID number of the person who was borrowing the bookAuthor, title, and the unique ID number of the book that was borrowedDate that the book was borrowedDate that the book was due to be returnedDate that the book was returned (or 0 if the book has not been returned yet)Which of the following CANNOT be determined from the information collected by the system?ResponsesThe total number of books borrowed in a given yearThe total number of books borrowed in a given yearThe total number of books that were never borrowed in a given yearThe total number of books that were never borrowed in a given yearThe total number of books that were returned past their due date in a given yearThe total number of books that were returned past their due date in a given yearThe total number of people who borrowed at least one book in a given year

2.Question 2You are the database administrator for a school. Student information is kept in a students table where students are tracked by student_id. Students have a grade point average listed for each semester in a table named grades where each student is referenced by student_id.The school is giving an award to all students who achieved a 4.0 grade point average during any semester. You need to generate a list of all the students who should get the award. You begin typing your query:What should you type in the blank space? (Please type your answer all in lower case. Example: select)1 point