Database Management SystemTU Board 2081
Consider the library database schema containing the tables given below where primary keys are underlined. USER (UserID, User name, Address) USES (UserID, BookID, Issued date, Returned date) BOOK…
10Consider the library database schema containing the tables given below where primary keys are underlined.
USER (UserID, User_name, Address)
USES (UserID, BookID, Issued_date, Returned_date)
BOOK (BookID, Book_name, Author, PublisherID)
PUBLISHER (PublisherID, Publisher_name, Address)
Specify the following queries in both SQL and Relational Algebra on this database schema:
a. Retrieve names of all books issued to the user "Hari".
b. Retrieve the names of all books published by "ABC publication".
c. Count the number of books published by the author "Ram".
A worked answer is on its wayMeanwhile, read the Database Management System notes for this topic.
Discussion
Loading…
More Database Management System questions
Consider an online Bookstore, from which customers can buy books. Each customer can place multiple orders. Each order has one or more books. The Bookstore…TU Board 208210Consider the following relational schema: Student( SID , SName, Dept, Year) Course( CID , CName, Credit) Enroll( SID , CID, Grade) Specify the following…TU Board 208210Define Normalization. Explain 1NF, 2NF and 3NF with a suitable example.TU Board 208210Differentiate between traditional file processing system and database approach.TU Board 20825Explain the concepts of schema, instance, and data independence.TU Board 20825Define relational constraints. Explain domain, entity integrity, and referential integrity with examples.TU Board 20825