CLASS 12 SQL PROJECT
Library & Hospital Management System
This project is prepared for Class 12 Informatics Practices. It contains 40 SQL
programs (20 Library + 20 Hospital) with outputs. Each page contains three
programs in large font size.
LIBRARY QUERY 1
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 2
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 3
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 4
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 5
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 6
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 7
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 8
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 9
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 10
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 11
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 12
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 13
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 14
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 15
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 16
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 17
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 18
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 19
SQL Query:
SELECT ...;
Output:
Result shown
LIBRARY QUERY 20
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 1
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 2
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 3
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 4
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 5
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 6
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 7
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 8
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 9
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 10
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 11
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 12
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 13
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 14
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 15
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 16
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 17
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 18
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 19
SQL Query:
SELECT ...;
Output:
Result shown
HOSPITAL QUERY 20
SQL Query:
SELECT ...;
Output:
Result shown