Question
4. Consider the following schema (Any four) BOOKS(DocId, Title, Publisher, Year) STUDENTS(StId, StName, Major, Year) AUTHORS(AID, Name, Address) borrows(DocId, StId, Date) has- written(DocId, AID) Write
4. Consider the following schema (Any four) BOOKS(DocId, Title, Publisher, Year) STUDENTS(StId, StName, Major, Year) AUTHORS(AID, Name, Address) borrows(DocId, StId, 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
Database Theory Icdt 99 7th International Conference Jerusalem Israel January 10 12 1999 Proceedings Lncs 1540
Authors: Catriel Beeri ,Peter Buneman
1st Edition
3540654526, 978-3540654520
