Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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 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

More Books

Students also viewed these Databases questions