PGM.
NO: 1
INPUT/OUTPUT:
Connected Successfully
Database created
Table created and values are inserted
Details of items whose price is below Rs. 10
('ER01', 'Eraser', 'Doms', 7)
('GP01', 'GelPen', 'Cello', 10)
('PL01', 'Pencil', 'Apsara', 6)
1
PGM. NO: 2
INPUT/OUTPUT:
1. Add Record
2. Update Salary
3. Display Records
0. Exit
Enter your choice:1
Enter employee number:1001
Enter name:KAVIN
Enter department:ACCOUNTS
Enter salary:45000
1. Add Record
2. Update Salary
3. Display Records
0. Exit
Enter your choice:1
Enter employee number:1002
Enter name:JANAVI
Enter department:HR
Enter salary:50000
1. Add Record
2. Update Salary
3. Display Records
0. Exit
Enter your choice:1
Enter employee number:1003
Enter name:CALVIN
Enter department:SALES
Enter salary:55000
1. Add Record
2. Update Salary
3. Display Records
0. Exit
2
Enter your choice:3
EMP_NO EMP_NAME DEPARTMENT SALARY
1001 KAVIN ACCOUNTS 45000
1002 JANAVI HR 50000
1003 CALVIN SALES 55000
1. Add Record
2. Update Salary
3. Display Records
0. Exit
Enter your choice:2
Enter empno:1001
Enter new salary:48000
RECORD UPDATED SUCCESSFULLY
1. Add Record
2. Update Salary
3. Display Records
0. Exit
Enter your choice:3
EMP_NO EMP_NAME DEPARTMENT SALARY
1001 KAVIN ACCOUNTS 48000
1002 JANAVI HR 50000
1003 CALVIN SALES 55000
1. Add Record
2. Update Salary
3. Display Records
0. Exit
Enter your choice:0
##### Thank you!!! #####
3
PGM. NO: 3
INPUT/OUTPUT:
1. Add record
2. Display record
3. Search record
4. Exit
Enter your choice:1
Enter Student ID:110
Enter name:SANJAN
Enter game:FOOTBALL
Enter grade:B
1 row inserted
1. Add record
2. Display record
3. Search record
4. Exit
Enter your choice:1
Enter Student ID:107
Enter name:GANESH
Enter game:BASKET BALL
Enter grade:A
1 row inserted
1. Add record
2. Display record
3. Search record
4. Exit
Enter your choice:1
Enter Student ID:118
Enter name:JASON
Enter game:BASKET BALL
Enter grade:B
1 row inserted
1. Add record
4
2. Display record
3. Search record
4. Exit
Enter your choice:1
Enter Student ID:103
Enter name:ARAVINDH
Enter game:FOOTBALL
Enter grade:A
1 row inserted
1. Add record
2. Display record
3. Search record
4. Exit
Enter your choice:2
(110, 'SANJAN', 'FOOTBALL', 'B')
(107, 'GANESH', 'BASKET BALL', 'A')
(118, 'JASON', 'BASKET BALL', 'B')
(103, 'ARAVINDH', 'FOOTBALL', 'A')
1. Add record
2. Display record
3. Search record
4. Exit
Enter your choice:3
Enter the game to search:BASKET BALL
Details of students who opted for: BASKET BALL
(107, 'GANESH', 'BASKET BALL', 'A')
(118, 'JASON', 'BASKET BALL', 'B')
1. Add record
2. Display record
3. Search record
4. Exit
Enter your choice:4
Thank You!!!
5
PGM. NO: 4
INPUT/OUTPUT:
1. Delete Employee
2. Display Records
3. Exit
Enter your choice:2
EMP_NO EMP_NAME DEPARTMENT SALARY
1001 KAVIN SALES 47000
1002 JANAVI HR 50000
1003 CALVIN SALES 45000
1. Delete Employee
2. Display Records
3. Exit
Enter your choice:1
Enter empno to delete:1003
RECORD DELETED
1. Delete Employee
2. Display Records
3. Exit
Enter your choice:2
EMP_NO EMP_NAME DEPARTMENT SALARY
1001 KAVIN SALES 47000
1002 JANAVI HR 50000
1. Delete Employee
2. Display Records
3. Exit
Enter your choice:3
##### Thank you!!! #####