0% found this document useful (0 votes)
6 views15 pages

Class 12 SQL Library & Hospital Project

The document outlines a Class 12 SQL project focused on Library and Hospital Management Systems, featuring a total of 40 SQL programs (20 for each system) along with their outputs. Each section presents three SQL queries in a large font size, demonstrating various functionalities. The project serves as a practical application of SQL skills for students in Informatics Practices.

Uploaded by

sharmaaryan74889
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
0% found this document useful (0 votes)
6 views15 pages

Class 12 SQL Library & Hospital Project

The document outlines a Class 12 SQL project focused on Library and Hospital Management Systems, featuring a total of 40 SQL programs (20 for each system) along with their outputs. Each section presents three SQL queries in a large font size, demonstrating various functionalities. The project serves as a practical application of SQL skills for students in Informatics Practices.

Uploaded by

sharmaaryan74889
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

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

You might also like