SQL Practical Project
File
A comprehensive Class 12 practical file demonstrating essential SQL operations
through five structured exercises. This project covers database creation, table
management, data manipulation, and advanced querying techniques.
Exercise 1: Student Database Operations
01 02 03
Create Student Table ALTER Operations Data Manipulation
Design table with ADMNO, CLASS-SEC, Add SEX attribute, modify CHAR to Update marks, sort by NAME/SCORE, delete
NAME, SCORE columns and insert sample VARCHAR, then drop SEX column to low scorers, and apply GROUP BY functions
student records. demonstrate table structure changes. for analysis.
Student Table: SQL Commands & Screenshots
Key SQL Operations
CREATE TABLE with appropriate data types
INSERT multiple student records
ALTER TABLE for structure modifications
UPDATE to increase marks by 10 for scores < 20
ORDER BY for ascending/descending sorts
DELETE records with SCORE < 10
GROUP BY with MIN, MAX, SUM, COUNT, AVG
Remember to capture screenshots of both your SQL commands and the resulting output tables for complete documentation.
Exercise 2: Employee Database Management
Table Creation Structure Changes Salary Operations
Build EMPLOYEE table with EID, NAME, Add HRA attribute, modify data type to Increase all salaries by 10%, sort by
SALARY, DEPT columns and populate DECIMAL, then drop HRA to show table SALARY and EID, delete specific
with realistic employee data. evolution. employee records.
Exercise 3: Library Database System
Database Creation 1
Create LIBRARY database with BOOKS table (book_id,
book_name, author_name, publishers, price, type, qty)
and ISSUED table with foreign key relationships.
2 Data Population
Insert comprehensive book records and issue tracking
data to demonstrate real-world library operations.
Advanced Queries 3
Execute SELECT with WHERE clauses, JOIN operations,
NULL handling, DISTINCT publishers, and statistical
functions.
Library Query Examples &
Expected Output
SELECT Operations
Books by First Publ. publishers, Text type books, ascending price order, and
JOIN queries showing issued books.
UPDATE & Analysis
Increase EPB publisher prices by 50, display NULL publishers, unique
publisher names, and statistical analysis.
Document each query's output with clear screenshots showing both the SQL
command and resulting data tables.
Exercise 4: Company
Database with JOIN
Operations
JOB Table
1 Create with JOBID (PK), JOBTITLE, SALARY columns for job
classification system.
Employee Table
2 Build with EID (PK), NAME, SALES, JOBID (FK) to establish
relationships.
JOIN Queries
3 Connect tables to display comprehensive employee-job
information and filtered results.
Company Database: Complex Query Operations
JOIN Query Examples
Employee details with job titles
High-performing sales staff (>130,000)
Employees with 'SINGH' in names
Maximum salary identification
JobID updates for specific employees
Key Focus: Understanding foreign key relationships and JOIN operations for relational database queries.
Exercise 5: Club Management System
CLUB Table Design Filtering Operations Statistical Analysis
Comprehensive coach database with Display KARATE coaches, salary ranges Gender-wise salary totals, DISTINCT sports
CoachId, CoachName, Age, Sports, (500-1000), names starting with 'A', and count, minimum male age, and average age
DateofApp, Pay, and Sex attributes. alphabetical sorting. by gender.
Project Completion Checklist
1 Screenshot Documentation
Capture clear images of all SQL commands and their corresponding
output results for each exercise.
2 Code Organisation
Structure your practical file with proper headings, exercise numbers, and
logical flow between operations.
3 Output Verification
Ensure all query results are visible and demonstrate successful
execution of SQL operations across all five exercises.
Final Tip: Create a professional A4 document combining code snippets,
screenshots, and brief explanations for comprehensive practical file
submission.
