1) Write Java application program to change the basic = basic + 500 of all the employees whose age is greater then 40 from employee table then display how many record updated
2) Write a program using JDBC for getting personal information - name, birthdate, sex, address, phone no, email-id & store it in database. Also provide list of all records, all male, all female & all minors (age below 18).
3) Write database application that prints different records from a table. Find out the name of table, no. of columns, no. of records and type of the columns.
4) Consider Bank table with attributes AccountNo,CustomerName, Balance, Phone and Address. Write a database application which allows insertion, updation and deletion of records in Bank table. Print values of all customers whose balance is greater than 20,000.
Academic requirements:
• Your work must be submitted as progremming og the given assignment along with output screen shots .
• Your work should be submitted in the formats outlined for each task in the assignment.