Library Management System

A database project for managing library operations

Project Overview

This project is a Library Management System, designed and developed as part of a database coursework. It covers the entire process, starting from conceptual and logical design (ERD) to the physical schema and implementation in C#.

Key Features

• User roles: Admin and Student Dashboards
• Book management: Add, update, and delete book records
• Admin sign-up and authentication
• Student book borrowing functionality
• Interactive forms built using Windows Forms (WinForms)
• Database schema implementation in SQL Server

Project Workflow

1. Designed the logical and physical ERD using database design tools.
2. Created the database schema in SQL Server.
3. Developed the front-end application using C# and WinForms.
4. Integrated the application with the SQL Server database for CRUD operations.

Files in the Repository

• AddBook.cs, AddBook.Designer.cs, AddBook.resx: Handles the form and logic for adding books.
• AdminDashboard.cs, AdminDashboard.Designer.cs, AdminDashboard.resx: Admin dashboard implementation.
• AdminSignUp.cs, AdminSignUp.Designer.cs, AdminSignUp.resx: Admin sign-up form and logic.
• Form1.cs, Form1.Designer.cs, Form1.resx: Main application form.
• LibraryManagementSystem.csproj: Project configuration file.
• StudentDashboard.cs, StudentDashboard.Designer.cs, StudentDashboard.resx: Student dashboard implementation.
• App.config: Configuration file for database connection strings.
• Program.cs: Entry point of the project.

Database Schema

The database schema includes tables for:

• Books: Contains book details such as title, author, and availability status.
• Users: Stores user information for both admins and students.
• Transactions: Tracks book borrowing and return activities.

How to Run the Project

1. Clone the repository to your local machine.
2. Open the project in Visual Studio.
3. Ensure the App.config file has the correct connection string for your SQL Server.
4. Compile and run the project.

License

This project is open-source. You can use and modify it as needed.

© 2025 Library Management System Project