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.
-
Notifications
You must be signed in to change notification settings - Fork 0
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.
sharz1/SQLServerLibraryMgmtSystemDB
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