This project contains SQL script files for setting up and managing a library database. It includes separate scripts for creating the database, defining tables, inserting sample data, and performing basic queries. The database schema allows for tracking books, authors, and borrowers, enabling basic library management functionalities.
To set up the library database on your local MySQL server, follow these steps:
-
Install MySQL: If you haven't already, install MySQL Community Edition from the official website: MySQL Community Downloads.
-
Clone the Repository: Clone this repository to your local machine using Git:
git clone https://github.com/your-username/library-database.git
- Run SQL Scripts: Execute the SQL script files in your MySQL client or command-line interface. Start with
create_database.sql
, followed bycreate_tables.sql
,insert_data.sql
, andperform_queries.sql
.
Once the library database is set up, you can use it to perform various library management tasks such as:
- Listing all books in the library
- Listing all authors
- Checking available books
- Listing books borrowed by a specific borrower
- And more!
Feel free to explore and modify the SQL queries to suit your specific requirements.
Contributions to the Library Database Management System project are welcome! If you have ideas for improvements, new features, or bug fixes, please feel free to open an issue or submit a pull request.
This project is licensed under the MIT License