Scribd
Upload
11 views18 pages

SQL Practical File for Class 12 Students

The document is a SQL practical file for a student named Prince Gupta from Class 12-A, detailing various SQL exercises. It includes practical questions on creating and managing tables for students, employees, libraries, companies, and clubs, along with SQL code and outputs. The file is structured with an index and practical sections that cover commands like ALTER, UPDATE, DELETE, and GROUP BY.

Uploaded by

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

SQL Practical File for Class 12 Students

The document is a SQL practical file for a student named Prince Gupta from Class 12-A, detailing various SQL exercises. It includes practical questions on creating and managing tables for students, employees, libraries, companies, and clubs, along with SQL code and outputs. The file is structured with an index and practical sections that cover commands like ALTER, UPDATE, DELETE, and GROUP BY.

Uploaded by

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

MY

SQL
FILE

CS Holiday Homework - SQL Practical File


Name: Prince Gupta

Class: 12 - A

Roll No: ___________

Teacher: Deepika Ma’am

Session: 2025 - 26

INDEX
[Link]. Practical Name Page No.
1 Student Table 1
2 Employee Table 4
3 Library Database 7
4 Company Database 10
5 Club Table 13

🔷 Practical Question 1: student table


🔹SQL CODE
TABLE

🔹ALTER
🔹ALTER TABLE

📸 figure : alter commands executed

🔹UPDATE

📸 figure : scores updated for students scoring less than 20


🔹ORDER BY
🔹DELETE

📸 figure : deleted records with score less than 10

🔹GROUP BY
🔷 Practical Question 2: employee table
🔷 SQL CODE

📸 figure : employee table created and data inserted


🔷 ALTER TABLE

📸 figure : alter commands executed

🔷 UPDATE TABLE
📸 figure : salary increased by 10%

🔹 ORDER BY
🔹DELETE

🔹GROUP BY

🔷 Practical Question 3: library database


🔹SQL CODE
🔹QURIES
🔹OUTPUT QUEIRS
🔷 Practical Question 4: company database
🔹 SQL CODE
🔹QUIRES

🔷
Question 5: club table
🔹 SQL CODE
🔹QURIES
🔹OUTPUT QURIES

You might also like