D C MONTESSORI [Link].
SCHOOL
I.T PRACTICAL FILE
SUBMITTED TO :- Jyoti
SUBMITTED BY :- RAMNEET KAUR
ACKNOWLEDGEMENT
I am deeply grateful to thos
e who made this project po
ssible. I express sincere gr
atitude to my teacher, [Ms.
Jyoti Sharma ]
, for their invaluable guida
nce and support. Special th
anks to my friends for their
encouragement and assist
ance.
INDEX
SQL QUERIES:-
TABLES USED:
• Emp table
• Dept table
QUERIES RUNNED:-
1. Write a query to display employee name, salary and department number who are not getting
commission.
2. Write a query to display name and job of those employees who don’t have manager.
3. Write a query to display the number of employees working in different types of jobs.
4. Write a query to display the name, monthly salary and annual salary (Sal *12) of all the
employees. The output should be in the following format: e.g. SMITH earns 800 rupees in a
month and 9600 rupees in a year.
5. Write a query to display the names and salary of all the employees in descending order of salary.
6. Write a query to display the details of only those employees whose names have only 4 letters.
7. List the count of employees in different departments (Dept No).
8. Write a query to display the sum of salaries of different employees working under different jobs.
9. Write a query to display the average salaries of only those jobs under which more than 3
employees are working.
10. Write a query to display the department no, average salary and average commission of different
departments in emp table having average salary more than 2000 and average commission more
than 750.
11. Write a query to change the salary of employee having empid as 7839 to 7000.
12. Write a query to display the senior most employee.
13. Write a query to display the name of employee having maximum commission along with the
department name.
14. Insert 5 records in the table created in the above query.
15. Write a query to add one more column address in the table employee.
16. Write a query To find the names of all teachers earning more than 50000.
17. Write a query To retrieve names of all the teachers starting from letter 'S'.
18. Write a query To list the names of teachers in alphabetical order.
[Link] a query To find total salary of all the teachers.
20. Write a query To find the maximum and minimum salary.
JAVA PROGRAMMING :-
1. MAGIC TEXT
2. ADDITION OF MR AND MRS BEFORE NAME
3. SIMPLE INTEREST CALCULATOR
4. CALCULAOR
5. LOGIN PASS
SQL QUERIES
Tables used:
1. Emp Table
2. Dept Table
1. Write a query to display employee name, salary and department number who are
not getting commission.
2 . Write a query to display name and job of those employees who don’t have manager.
[Link] a query to display the number of employees working in different types of jobs.
[Link] a query to display the name, monthly salary and annual salary (Sal *12) of all
the employees. The output should be in the following format: e.g. SMITH earns 800
rupees in a month and 9600 rupees in a year.
[Link] a query to display the names and salary of all the employees in descending order
of salary
[Link] a query to display the details of only those employees whose names have only 4
letters.
[Link] the count of employees in different departments (DeptNo).
[Link] a query to display the sum of salaries of different employees working under different
jobs.
[Link] a query to display the average salaries of only those jobs under which more than 3
employees are working.
[Link] a query to display the department no, average salary and average commission of
different departments in emp table having average salary more than 2000 and average
commission more than 750.
[Link] a query to change the salary of employee having empid as 7839 to 7000.
[Link] a query to display the senior most employee.
[Link] a query to display the name of employee having maximum commission along with the
department name.
[Link] 5 records in the table created in the above query.
[Link] a query to add one more column address in the table employee
16. Write a query To find the names of all teachers earning more than 50000.
17. Write a query To retrieve names of all the teachers starting from letter 'S'.
18. Write a query To list the names of teachers in alphabetical order.
[Link] a query To find total salary of all the teachers.
20. Write a query To find the maximum and minimum salary.
JAVA PROGRAMMING
[Link] Text
• GUI (design) :-
• SOURCE (CODING):-
• OUTPUT :-
[Link] OF MR AND MRS BEFORE NAME :-
• GUI (design):-
• SOURCE CODE:-
• OUTPUT:-
[Link] INTEREST CALCULATOR:-
• GUI (design):-
• SOURCE CODE:-
• OUTPUT:-
[Link]:-
• GUI (design) :-
• SOURCE CODE:-
• OUTPUT:-
[Link] PASS
• GUI:-
• SOURCE CODE :-
• OUTPUT :-
CONCLUSION
In conclusion, this project has demonstrated t
he powerful synergy between Java and SQL in
developing robust, efficient, and scalable appli
cations. By leveraging Java’s object-
oriented capabilities and SQL’s efficient data m
anagement, we have successfully created a sy
stem that meets the project's requirements an
d exceeds performance expectations. This wo
Rk not only underscores the potential of integr
ating these technologies but also sets a found
ation for future enhancements and innovations
. Thank you for your time and interest.