📌 Project Overview
This project is a beginner- friendly Library Management System built using SQL. It includes essential database structures and queries to manage borrowed books.
📂 Database Schema
The table consists of the following tables:
-
Authors
• Author_id (Primary Key)
• Author_name -
Borrowers
• Borrower_id
• Book_id(Foreign Key)
• Borrowed_date -
Books
• Book_id(Primary key)
• Title
• Author_id(Foreign key)
• Published_date
• Genre
🪓SQL Queries
This project includes the following SQL functionalities:
-Database Creation
-Insert Statements