Database Management System

School Database

Designed and implemented a relational database system for a university library management application.

Designed and implemented a complete database system for managing library operations including book inventory, user accounts, borrowing history, and overdue notifications.

Project components:

  • ER diagram design
  • SQL schema implementation
  • Stored procedures and triggers
  • Transaction management
  • Query optimization
  • Python interface using SQLAlchemy
← Back to Projects