ELibraryDB

a database system for a library that tracks book information, including authors, categories, publishers, and availability. Created stored procedures for searching and adding books, and implemented a trigger to update book availability when a customer borrows or returns a book. Designed a relational schema to ensure efficient data storage and retrieval, and optimized queries for fast performance. Used SQL Server Management Studio and Visual Studio for database development and integration with a web application.