Scribd
Upload
9 views17 pages

SQL Operations for Student and Employee Tables

The document outlines practical SQL exercises involving various database tables including student, employee, library, company, and club tables. It includes commands for altering tables, updating records, deleting entries, and grouping data. Each section is accompanied by figures illustrating the executed SQL commands and their outcomes.

Uploaded by

aadya20sharma
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
9 views17 pages

SQL Operations for Student and Employee Tables

The document outlines practical SQL exercises involving various database tables including student, employee, library, company, and club tables. It includes commands for altering tables, updating records, deleting entries, and grouping data. Each section is accompanied by figures illustrating the executed SQL commands and their outcomes.

Uploaded by

aadya20sharma
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

🔷 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