Scribd
Upload
11 views

Library Management System-SQL Project (2)

Uploaded by

iconiceditorrahulz
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views

Library Management System-SQL Project (2)

Uploaded by

iconiceditorrahulz
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 26

SQL PROJECT: Library Management System

We are going to build a project based on Library Management System. It keeps track all information about books in the library,
their rental cost, status and total number of books available in the library.

Step-01
Creating Database for our project
Step-02
Creating the table "Branch"
Step-03
Creating the table "Employee"
Step-04
Creating the table "Customer"
Step-05
Creating the table "Isssue Status"
Step-06
Creating the table "Return Status"
Step-07
Creating the table "Books"
#Show all tables
Step-08
Insert Values into each tables
Inserting book details
**Queries**
1. Retrieve the book title, category, and rental price of all available books.
2. List the employee names and their respective salaries in descending order of
salary.
3. Retrieve the book titles and the corresponding customers who have issued those books
4. Display the total count of books in each category.
5. Retrieve the employee names and their positions for the employees whose salaries are above Rs.50,000.
6. List the customer names who registered before 2022-01-01 and have not issued any books yet.
Add a new column, 'Branch_no', to
the 'employee' table to store the branch
number for each employee working at a
specific branch
7. Display the branch numbers and the total count of employees in each branch.
8. Display the names of customers who have issued books in the month of June 2023.
9. Retrieve book_title from book table containing history.
10.Retrieve the branch numbers along with the count of employees for branches having more than 5
employees.

*******

You might also like