Data Analysis Portfolio Project on Bookkeeping PART 1

Project Overview:
The Library Management System is a simple project designed to manage and maintain the records of books in a library. This project involves creating a database for storing book information, author details, borrower records, and transactions related to borrowing and returning books.

Objective:
By the end of this project, You will be able do the following:-
1. How to use some SQL Synthes to execute commands
2. How to create a database.
3. How to create tables.
4. How to add data to tables
5. How to query data
I will also be able to use some SQL synthesis to answer some questions Like: -
1. How to Query data to find out the Books Borrowed by a Specific Borrower:
2. Query to Find Overdue Books
3. Create a Stored Procedure for Borrowing a Book

File:- https://docs.google.com/document/d/1k...