1.

Create a Spring Java configuration to maintain Employee details such as employee id, employee
name, and departmentand perform the following database operations.
i. Insert a new employee details
ii. Remove employee details based on employee id

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

2. Create a Spring Boot application to maintain Employee details such as employee id, employee
name, and department.

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

12. Create the Spring REST version of an online train inquiry application using InfvRail

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

3. Create a Spring Java configuration to maintain Employee details such as employee id, employee
name, and departmentand perform the following database operations.
i. Insert a new employee details
ii. Remove employee details based on employee id
iii. Search all employee

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

4. Considering the Spring application of Employee Management scenario, add the following
functionalities:
i. Insert six employee records with appropriate data.
ii. Display three employees per page
iii. Sort employees in descending order of the first name
iv. Retrieve and display the first four records in descending order based on employee salary.

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

5. Considering the Employee Management scenario, add the below properties to the
existingEmployee class:

i. Implement the following requirements to the application:

ii. Retrieve the employees based on address

iii. Update the employee Salary details for the given employee Band Level as follows:

Employee Band Level Employee Salary

A 15%

B 10%

C 5%

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

6. Develop the data access layer of the Employee Management Application to perform the database
operations given below using Spring Data JPA

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

7. Develop the data access layer of the Employee Management Application to perform the
database operations given below using Spring Data JPA.
Add the operations given below:
i. Add custom repository implementation for retrieving employee records based on first Name
and las t Name or phone Number or email or dept.
ii. Add custom repository implementation for retrieving the maximum salary of employees in
an organization and display the details on the console.
iii. Update employee last name based on employee id by setting timeout as 5 seconds using
Spring Data JPA annotations.

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

8.Develop the data access layer of the Employee Management Application to perform the database
operations given below using Spring Data JPA.
Add the operations given below:
i. Retrieve an employee record based on employee id and display employee details on
console.

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

9.Implement the required repository using the collection

i. Flight Repository interface

ii. Flight Repository Impl class

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

10.Create a Spring Boot application to maintain Employee details such as employee id,
employee name, and department and perform the following database operations.
i. Insert a new employee details
ii. Remove employee details based on employee id
iii. Search all employee

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

11. Implement the following functionalities in the application:

For User:
i. Sign up
ii. Login
iii. View Profile
iv. View all life coaches
v. Book an appointment
vi. View upcoming appointments
vii. Reschedule an appointment
viii. Cancel an appointment

For Life Coach:

i. Sign Up
ii. Login
iii. View Profile
iv. View upcoming schedule

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

12. Create the Spring REST version of an online train inquiry application using InfvRail

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

13. Create the Spring REST version of an InfyGoonline Flight ticket booking application.

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

14. Implement the backend of InfyDUGuesstimate using Spring REST

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

12. Create the Spring REST version of an online train inquiry application using InfvRail

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

15. Implement the following functionalities in the Express Movies application:
i. Add movie
ii. Search movie and director details
iii. View movies
iv. Update movie and director details
v. Remove movie
vi. Software Requirement
vii. Spring Tool Suite(STS) / Eclipse IDE
viii. MySQL

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER

16. Implement the SIM activation process with following functionalities.

i. SIM validation
ii. Show special offers
iii. Customer validation based on email and date of birth
iv. Validate Customer details using first name, last name and email
v. Update address details
vi. Customer ID proof validation

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-

required/Procedure Program/Drawing &Results Voce Record Total

20 30 30 10 10 100

MARK IN WORDS

INTERNAL EXAMINER EXTERNAL EXAMINER