This project is a simple SQL-based system to manage library data, including books, members, and borrow records. It demonstrates basic SQL operations such as creating tables, inserting data, and querying or updating records.
- Run the scripts in
schema/
to set up the database and insert sample data. - Use the scripts in
queries/
to fetch or modify data as needed.
The sample data included in this project (e.g., books, members, and borrow records) was generated using ChatGPT for demonstration purposes. Feel free to modify it to suit your requirements.
- Table creation
- Foreign key relationships
- Data insertion
- SELECT, UPDATE, and JOIN queries