About this document
SQL Queries for Library Database Management by طلحہ بن اکرم is a document available to read on EtoBox.
This document describes the schema for a LibraryDatabase including tables for books, authors, publishers, branches, book copies, lending cards, and book lending. It provides the table structures and sample data. It also lists 5 queries: 1) to retrieve book details with id, title, publisher, authors and copies; 2) to find borrowers who borrowed more than 3 books from Jan to Jun 2017; 3) to delete a book and update related tables; 4) to partition the book table by publication year; and 5) to create a view of
- Author
- طلحہ بن اکرم
- Language
- EN