A set of SQLServer queries to CREATE and populate a database for a library book management system across a few (fictional) public library branches in Houston TX and stored procedures for common queries to the DB. Includes Book (titles) table, Authors table, Publisher table, Library Branch table, Book Copies table, Borrower table (with CardNo PK), and Book Loans table, along with 7 stored procedures to pull info such as the Book Title and Borrower's Name and Address for all books checked out and due today at a certain branch.
sharz1/SQLServerLibraryMgmtSystemDB
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
About
A set of SQL Server queries and stored procedures to CREATE and SELECT from tables in a database for a library book management system across a few (fictional) public library branches in Houston TX.
Topics
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published