Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4. Consider the following schema (Any four) BOOKS(Docld, Title, Publisher, Year) STUDENTS(Stld, StName, Major, Year) AUTHORS(AID, Name, Address) borrows(Docld, Stld, Date) has-written(DocId, AID) Write the
4. Consider the following schema (Any four) BOOKS(Docld, Title, Publisher, Year) STUDENTS(Stld, StName, Major, Year) AUTHORS(AID, Name, Address) borrows(Docld, Stld, Date) has-written(DocId, AID) Write the following queries in SQL (a) Display list of books grouped by publisher. (b) Display a list of books whose title includes the word "Database" (c) Retrieve a list of books titles which are published by "Mc Graw Hill" in Year of 2016 from BOOKS relation. (d) Add a new attribute DoB (date of birth) to the student table. (e) Display the total numbers of books the library has
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